Primary Key/Alternate Key

[Dominick D.]

Hello All; I want to know if you can set up an alternate key in a table? I
know about setting up a primary key, but how do you set up an alternate key?
Thanks.

 

[John W. Vinson]

Hello All; I want to know if you can set up an alternate key in a table? I
know about setting up a primary key, but how do you set up an alternate key?
Thanks.

Just what do you mean by "an alternate key"???

You can create up to 32 Indexes on a table; each index can span one to ten
fields, and can optionally be unique. So if you want FieldA to be the Primary
Key, and FieldB to be a non-null unique value, set FieldB's Required property
to Yes, and use the Indexed option on the field properties to create a unique
index on the field.

If you have some other meaning for the term please explain.