Referential Integrity Question

[micki_free]

I have two tables. One of the tables has two foreign keys in it that are the primary key in the other table.

How do i set up two seperate relationships between the tables as one table uses the primary key of the other table as a foreign key in two fields

 

[boblarson]

I have two tables. One of the tables has two foreign keys in it that are the primary key in the other table.

How do i set up two seperate relationships between the tables as one table uses the primary key of the other table as a foreign key in two fields

Add the main table twice and link the one field once to each of the foreign key fields.