Multiple primary keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me how multiple primary keys function.

Does access only prevent duplication of records if all fields set as primary
keys are duplicated or does it prevent entry of duplicated data within any of
these fields?
 
Your phrasing is incorrect. You can only have one primary key.
You can have a primary key that consist of multiple fields.
A multiple field key allows only one instance of the combined data.
Examples --
ABC XYZ
ABC XYY
ABC XYX
But any of the above combinations can not be entered twice.
 
Back
Top