Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Require unique values for a field

Log in to subscribe to topics and get notified when content changes.

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

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. The system does not allow you to make a field unique while there are duplicate values in the table.


  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.
    Unique field in Dictionary Entry form
  5. Update.