Relatings tables

Hi Chris,

Thank you for your question and welcome to the forum.

Access assigns the one part of a relationship to the table with the Primary key and the Many to the Foreign key in the related table.

e.g. Customer table and Orders table:

Primary Key - CustomerID in the Customers table
Foreign Key - CustomerID in the Orders table

Do you mean a junction table where you have multiple foreign keys linking to Primary keys in other tables?

Regards

Simon