Unanswered: Foreign key points at more primary keys, how?
Hey guys i have my db made of 2 tables:
1 is named Personnel and is as following:
ID First Name Last Name Access Authorization (varchar (2))
the other is named Assets and is as following:
ID Description Authorized User
My problem is that 1 user can have access to more areas, so I thought to make another table called area.
This would have :
etc, and they'd be primary keys. how can i make a person having access to more areas??
I thought since Access Authorization is a foreign key could point at more primary keys (X1, X2 etc) but I have no idea how to do it!
Could someone help?