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, the program automatically populates this field with 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 as the key field in a table.
To change 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, Quick Base 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.
© 1999-2019 QuickBase, Inc. All rights reserved. Legal Notices.