Primary Key

[Parra]

Can a table have 2 primary keys?

 

[Joe4]

Yes, I commonly used 2 to 3 fields for primary keys.

In Design View of the table, click on the box to the left of the field so that the whole row is highlighted. Then press Control and click the same box for the 2nd primary key, and select "Primary Key". It should show keys next to both fields.

 

[Parra]

Thanks I was able to do what said, but then when I tried to use one of the primary key fields in a one to many relationship, I was unable too.

Parra

 

[Joe4]

Could you give a detailed example of what it is you are trying to do (examples of your table structures, data, and how you are trying to connect them)?

 

[Mudface]

You would need to use both the primary keys in the join (ie have 2 foreign keys in the joined table).