Setting key fields for tables

Quickbase 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, Quickbase 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 contain 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, Quickbase 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, Quickbase 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.