About key fields
Quickbase requires each table to include one field that contains a unique value for each record. This is called the key field. Key fields ensure that records that are identical in every other way always have a unique identifier.
By default, the key field on a table is the Record ID#. As you add records, Record ID# automatically includes a new unique number.
You might choose to set a key field that is not Record ID# because you want the key field to contain data more meaningful to your work. For example, a part number, account number, or employee ID number.
Requirements for key fields
A key field:
- Must be unique
- Cannot contain a formula
If you are setting an existing field to be a key field, all values in the field must already be unique.
Only certain field types can be set as key fields:
|Can act as key fields
|Cannot act as key fields
Changing the key field:
Open the table with the key field you want to change.
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.
When you create your own key field, Quickbase automatically displays it as a required field on the table's forms.