relationship

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hi,

I'm not sure how to go about this. Can someone point me in the right
direction?

I have two tables. There are two fields in one table that will match two
fields in the other table. When I change the CurrentRevision value in
tblRevisions, I want matching record in tblOnTimeDelivery to change the
CurrentRevision value also.

Here's what I have:

tblRevisions
*JobNumber
*CurrentRevision
and other fields

tblOnTimeDelivery
*JobNumber
*CurrentRevision
and other fields

Thanks for your help,
Joel
 
Joel

From your description, I'm having a bit of trouble identifying the primary
keys you're using for your two tables. I believe I understand that a record
in one (Revisions) can be matched up with a record in the other
(OnTimeDelivery) using the two fields you mentioned, but I'm not seeing how
the two tables are related.

For instance, can a single job/revision have only one OnTimeDelivery record
(i.e., 1-to-1)?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Hi,

I'm not sure how to go about this. Can someone point me in the right
direction?

I have two tables. There are two fields in one table that will match two
fields in the other table. When I change the CurrentRevision value in
tblRevisions, I want matching record in tblOnTimeDelivery to change the
CurrentRevision value also.

Here's what I have:

tblRevisions
*JobNumber
*CurrentRevision
and other fields

tblOnTimeDelivery
*JobNumber
*CurrentRevision
and other fields

Thanks for your help,
Joel
Click to expand...

You can use a two-field primary key and a two-field relationship, with
referential integrity enforced and Cascade Updates set to Yes. In the
relationships window, add the two tables; drag JobNumber to JobNumber,
CurrentRevision to CurrentRevision. Check the Enforce and Cascade Updates
checkboxes.
 
Back
Top