Require unique values for a field

  • 릴리스 버전: Australia
  • 업데이트 날짜 2026년 03월 12일
  • 소요 시간: 1분

    • 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.

    시작하기 전에

    Role required: personalize_dictionary

    이 태스크 정보

    By default, fields are created without this constraint. A field can have unique values only if there aren't already duplicate values in the database for that field. The system doesn't allow you to make a field unique while there are duplicate values in the table.

    The system also doesn't allow you to add a unique index if a non-unique index already exists. In this scenario, you can't select the Unique check box on the form; instead, the system directs you to the Tables & Columns module, so you can drop the non-unique index, and then create the unique index.

    프로시저

    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.