By definition you cannot have multiple primary keys.
You can have a primary key that is composed of multiple fields.
You can have additional indexes that are composed of either a single field
or multiple fields.
To view/change index definitions for a table the easiest way is to open the
table in design view and then select View->Indexes from the main menu and
define any additional indexes you want.
You can have a maximum of 32 indexes for a single table; you can have a
maximum of 10 fields per index.
By definition you cannot have multiple primary keys.
You can have a primary key that is composed of multiple fields.
You can have additional indexes that are composed of either a single field
or multiple fields.
To view/change index definitions for a table the easiest way is to open
the table in design view and then select View->Indexes from the main menu
and define any additional indexes you want.
You can have a maximum of 32 indexes for a single table; you can have a
maximum of 10 fields per index.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
