Unique Record

[Santosh Puthran]

I am having a table ABC with fields. The field names are
Customer , Division, Account Number.

I want to have unique records for the field "Customer"
only. How should I do in Access ?

 

[tina]

you can set the "Customer" field as the table's primary
key. if you already have a primary key field and don't
want to change it, you can set the field index's Unique
property to Yes. do as follows
open the table in design view.
click on the Customer field.
in the Field Properties list (bottom half of the window),
change the Indexed property to Yes (No Duplicates). it's
available in the droplist.