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

A

aa

How do I set a filed, other then the primary key, to hold unique values and reject duplicates?
 
A

Allen Browne

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?
 
Top