G Guest Sep 18, 2006 #1 I have a composite key made up of two fields. How would I create a relationship between this table and another (foreign) table?
I have a composite key made up of two fields. How would I create a relationship between this table and another (foreign) table?
J Jeff Boyce Sep 18, 2006 #2 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/
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/
