Primary Key/Alternate Key

  • Thread starter Thread starter Dominick D.
  • Start date Start date
D

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.
 
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.
Click to expand...

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.
 
Back
Top