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