Prevent duplicate values from being entered in a combination of fields
- Open the table in Design view.
- Create a multiple-field index using the fields you want to prohibit duplicate values for. Leave the Indexes window open when you have finished defining the index.
How?
- In the upper portion of the Indexes window, click the new index name.
- In the lower portion of the Indexes window, click the Unique property box, and then select Yes.