Force Entries in a Field to Be Unique

There are certain fields that you never want to contain duplicate values. This might be a field containing the Employee ID or Invoice Number. You can easily prevent a field from having duplicate values by making it unique. In other words, for each record, the value in the field must be different.

To make a field unique:
  1. Open the field's properties page.

  2. In the Basics section, select the Must be unique check box.

  3. Click Save.

Note: You can't make a List - User field unique. The check box does not appear in properties for this type of field.

Related Topics: