Advanced Microsoft Access 2013 Tutorial | Multiple Field Primary Keys

[Cuocdoivantuoidepsao]

Your tutorial help me. Thank you alot.

[combinatix]

What is the advantage of creating PRIMARY KEY across multiple fields when the same result can be achieved by creating UNIQUE INDEX across raceID + raceEMployee and keep the resultID as a PK? I thought the PK's purpose is to uniquely identify a single record in a table.

[CorleneGreenwood]

thank you so much.... you explained that perfectly

[dww]

Great, but how do you relate the table with two primary keys to another table ?