Setting key fields for tables

Quick Base requires each table to include one field that contains a unique value for each record, called the key field. This field ensures that records that are identical in every other way always have a unique identifier. Usually, Quick Base creates this field for you and names it Record ID#. As you add records, Record ID# automatically includes a new unique number.

If you want, you can designate another field in a table as the key field. This field must unique values. The advantage to choosing a different field is that it might contain a value that's more meaningful such as part number, account number or employee ID# . Or, a key field can be a text type field instead of a numeric field. When you create your own key field, Quick Base displays it as a required field on the table's entry forms.

Note: You cannot specify a List - user or Multi-select text field, or any formula field, as the key field in a table.

To change the key field:
  1. Open the table with the key field you want to change.

  2. Select Settings.

  3. Select Fields.

  4. Select a field, then select the Set Key button at the top of the list of fields. A Change the Key Field dialog box opens.

    If your table is a parent table in one or more relationships, the dialog that displays contains a warning. When you change the key field in a parent table, Quick Base makes changes to other tables in the app in response to the key field change.

  5. In the dialog box, select the Set Key button to finish.