microsoft database training - Manual Entry of Unique Number

Dear Matt

Thank you for attending the Access Intro training. It was a pleasure.

This is an Interesting question. I appreciate the fact that sometimes you want a field where the data doesn't duplicate but don't want that to be your primary key or autonumber.

Please follow these steps:

Step1:
Simply go to the design view of the table.

Step 2:
Click on the field that you don't want the data to be duplicated

Step 3:
In the property for that field you'll see Indexed (normally second to the last at the bottom).

By default the indexed is set to No.

Click on the arrow and choose yes (NO Duplicates)

Please note that when you go back to the Datasheet view and try to duplicate the data in that field it does allow you to enter the data and also allows you to go to the next field in that record but as soon as you try to go to the next record or try to click away from the record it gives you an error message which clearly says that you can't have duplicate data and therefore the user will be forced to change the data!!

I hope this answers your query.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003