Prevent duplicate values from being entered into a field

See Also

1. Open the table in Design View

2. Select the Index tab

3. To add a new index definition, select Add from the Index menu

4. In the Index Name column enter the name of the index

5. In the Unique column, click the arrow and select True

6. Right-click in the Field Name grid and select Add

7. Click the arrow to select the field for the index

8. Select Save… or Save As… from the File menu when you are ready to save the table