Link Primary Key to two fields in second table

  • Thread starter Thread starter DewSweeper
  • Start date Start date
D

DewSweeper

I have a "People" table that I would link to an "Orders" table. The People
table has a record for each individual. A record in the orders table will
have multiple "People" in it (e.g., Person Placing the Order, Technical
Contact, Budget Officer, etc.). I would like to link the Primary Key of the
"People" table (personID) to multiple fields in the orders table and enforce
referential integrity. Access and SQL Server both disallow this. Is there a
way around this? Any thoughts are appreciated.
 
Hi Dew,

Access does allow this...

when you are in the relationship window, drag the relationship from
People to the first field, check Referential Integrity (RI)

now drag a relationship from People to the second field

A dialog box will come up that says:

A Relationship already exists
Do you want to edit the existing relationship? To create a new
relationship, click No

just click NO -- and you will create another relationship and you can
check RI. Access will put a second copy of the People table on the diagram.


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Thank you Steve and Strive4Peace for the fast and very helpful responses.

Both suggestions work for me.
 
Back
Top