a filed, other then the primary key, to hold unique values

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

How do I set a filed, other then the primary key, to hold unique values and reject duplicates?
 
Open the table in design view.
Select the field.
In the lower pane, set the Indexed property to:
Yes (No Duplicates).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

How do I set a filed, other then the primary key, to hold unique values and
reject duplicates?
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

primary key - concatenated or autonumber? 6
No Primary Key! 4
Primary Key 2
case-sensitive primary keys 10
Mail as primary key 1
Primary Key 4
Update primary Key. 1
Question re: setting Primary Key 2

Back
Top