Require unique values for a field

You can require that a field's values are unique. This means no two records have the same value for that field.

Before you begin

Role required: personalize_dictionary

About this task

Warning: Making a field unique when the corresponding table already has different values for that field causes data loss. All duplicate records are deleted.

By default, fields are created without this constraint. A field can have unique values only if there are not already duplicate values in the database for that field.

Procedure

  1. Verify that no records in the table for the field have values, or that they all have the same value.
  2. Right-click the field label in the form and select Configure Dictionary.
  3. Configure the form to add the Unique field if it does not already appear.
  4. Select the Unique check box.
  5. Update.