table relationships - multi field

D

dwc

I have three tables - Customer (customer ID is key).
Contact - key is[Customer number]&"*"& [Contact ID]
Contract (key is [Customer number]&"*"&[Contact ID]&"*"&[contract Year]

1) How do I set up the relationships between the three tables?
 
D

Douglas J Steele

While in the Relationships view, drag the Customer ID from the Customer
table onto the Contact table and make sure that the resultant form is
correct. Then, select both Customer number and Contact Id from the Contact
table and drag them onto the Contract table.
 
Top