Add a key as the first key

Applies to User Roles:

System Administrator

Example: Add the language.key field as a No Nulls key to the unitofmeasure database dictionary record.

In this example, you add the language.key field to the unitofmeasure record and assign it as the first key with a property of No Nulls. This field is a required field in the record.

To add a key as the first key:

  1. Log in to the Windows client.
  2. From the System Navigator, click System Definition > Tables > unitofmeasure > Keys.
  3. In the Keys section, click New.
  4. In the General section, click the Type field. For this example, select No nulls in the Type list as the key type.

    The following key types are valid:

    • Nulls and duplicates – allows nulls and duplicates in all the fields in the key.
    • No nulls – allows duplicates, if selecting No nulls, the key must contain data in at least one of the fields in the key.
    • No duplicates – allows null records but not duplicates. Although the data must be unique, but the field may be left blank.
    • Unique – must contain unique data and cannot be left blank.
    • IR key – files that contain an IR key must also contain another key that is Unique, with No nulls, No duplicates or Nulls, and Duplicates. A Service Manager file can contain only one IR key.
  5. Click Add.
  6. From the Choose a field to add to the key dialog, select the language.key field, and then click OK.
  7. In the Keys section, select the key you added (language.key in this example), and click Up.

    The key language.key now appears as the first key in the list of keys in the database dictionary record. All other keys are moved down the screen.

  8. Once you are finished adding keys to the table, click Save and then click OK to confirm your changes.

    Service Manager automatically updates and regen the file.

  9. To remove the key, do the following:
    1. Select the key, and then click Delete.

    2. Click Save.

Related topics

Adding a key
Alias fields
Arrayed structures
Methods for deleting database dictionary records
Deleting a key
Methods for updating database dictionary records
Modifying a key
Database dictionary

Access the Database Dictionary utility
Add keys to bottom of the key list
Delete a key
Insert a key between other keys
Modify keys: Nulls and duplicates to unique
Open a database dictionary
Regen a database dictionary