Set the Key Field of a Table

Say you've got two records that contain exactly the same information. How do you tell them apart? How does Quick Base tell them apart? To avoid confusion, Quick Base requires each table to feature one field that contains a unique value for each record. This is called the key field. This field ensures that records which are identical in every other way always have one 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. Of course this must be a field that contains unique values. The advantage to choosing a different field, is that it might contain a value that's more meaningful than an arbitrary number. For example, fields like Part Number, Account Number or Employee ID# usually work well. (If you'd prefer, you can make the key field 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 form.

Note: You cannot specify a List - User or Multi-select Text field as the key field in a table.

To change the key field:
  1. In the table bar on any application page, click the table with the key field you want to change, then click SETTINGS, then click Fields.

  2. Select a field, then click Set Key button.

    A Change the Key Field dialog box opens.
    If this table is a master table in one or more relationships, the dialog that displays contains a warning and a link to get more information.

    When you change the key field in a master table, Quick Base makes changes to other tables in the application in response to the key field change.

  3. Click the Set Key button. A key icon () appears next to that field.


Go back      |       |   

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.