Can Access database have secondary key?

Hi,

I'm trying to add key in to my tables. Is it possible to add secondary key?

Thanks,
Sarah

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.


"sg" wrote in message
...
Hi,

I'm trying to add key in to my tables. Is it possible to add secondary
key?

Thanks,
Sarah

Bill,

That's great help. Thanks so much,
Sarah
"Bill Edwards" wrote in message
...
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.


"sg" wrote in message
...
Hi,

I'm trying to add key in to my tables. Is it possible to add secondary
key?

Thanks,
Sarah