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:
-
Open the table with the key field you want to change.
-
Select Settings.
-
Select Fields.
-
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.
-
In the dialog box, select the Set Key button to finish.
