Prevent duplicate values from being entered in a combination of fields

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 first field for the index

8. Move to the next row in the Field Name grid by pressing the DOWN key or right-click and select Add. Select the second field for the index. Repeat this step until you have selected all the fields you want to include in this unique index

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