Composite Key Relationship

[Murp]

I have a composite key made up of two fields. How would I create a
relationship between this table and another (foreign) table?

 

[Jeff Boyce]

Include corresponding (foreign key) fields in the other table. If you have
10 fields making up a composite primary key in table1, you'd need the same
10 fields (as foreign keys) in table2.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/