Delete a Field That Is Part of a Relationship

A relationship between tables can involve many different fields (read more). You can delete almost any field that is part of a relationship except a reference field. To delete a reference field, you must first delete the relationship itself. Then, within the details table, manually delete the reference field.

When you delete a field, Quick Base deletes all the data in the field.

To delete a field that is part of a relationship:
  1. Open the application which contains the relationship you want to edit.

    If you've created a relationship between tables in two different applications, open the application that contains the details table. (Don't know what this is? Read about relationships.)

  2. Open table relationships in one of the following ways:

    Note: Unless you've created a relationship across separate applications, you can select either the master or the details table to delete a field from the relationship.

  3. Click the relationship that you want to edit.

    Quick Base displays the Relationship Properties page, which lists fields that are part of the relationship. The left side of the page shows fields in the Master table and the right side of the page shows fields in the Details table.

  4. Locate the field that you want to delete, and click its Del button.

  5. Usage information for that field displays. Click Delete Field in the page bar.

  6. Within the confirmation prompt that displays, click Delete.

  7. Click Done in the page bar to return to the Relationships list.

Related Topics:


Go back      |       |   

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