Delete a Relationship

When a relationship isn't working out, it's easy to call it off (in QuickBase, anyway). Before you delete a relationship, understand that you'll lose any data you've entered in fields belonging to that relationship. (Don't know what these fields are? See about relationships.)

To delete a relationship:

1. Open the application which contains the relationship you want to delete.

   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:

   • In the table bar on any application page, click the name of one of the tables in the relationship. Within the menu that appears, select Customize --tablename-- Table > Relationships.

   • In the menu bar on any application page, select Customize > Tables. Within the list on the left side of the page, select one of the tables in the relationship, and then click the Relationships tab.

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

3. Locate the relationship that you want to delete, and either:

• Click its Delete icon ().
  OR

• Click the name of the relationship, and then click the Delete This Relationship button on the Relationship Properties page.

4. Review the confirmation page that QuickBase displays, click Delete This Relationship again, and then click Delete to confirm the action.

   QuickBase displays a message letting you know how many fields it deleted. When you delete a Relationship, QuickBase deletes all the fields that comprise the relationship except the reference field itself, which is not deleted. This field reverts to a regular field again. To avoid confusion you should delete this field too.

5. Delete the reference field.

   On the upper right of the Usage tab that appears after you delete the relationship, click the Delete this Field button.

   Review the confirmation page that QuickBase displays, and click Delete to confirm the action and return to the Relationships tab.

If you miss this opportunity for some reason, rest assured that you can delete the reference field at any time within the detail table's Fields screen. Customize --tablename-- table > Fields. Locate the old reference field and click its Delete button.