Require unique values for a field

The system allows you to require that a field's values be unique. When this is done, the system will not let 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.