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:
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.)
Open table relationships in one of the following ways:
From a table involved in the relationship you want to change, click SETTINGS in the page bar. Click Table-to-table relationships.
From the relationship list, choose a table involved in the relationship you want to change from the dropdown on the left side of the page.
Note: Unless you've created a relationship across separate applications, you can select either the master or the details table to delete the relationship.
Locate the relationship that you want to delete, and either:
Click its Delete
Click the name of the relationship, and then click the Delete relationship button on the page bar.
Review the confirmation page that QuickBase displays, click Delete on the page bar, then click Delete on the dialog that displays 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 are part of 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.
Delete the reference field from the Usage tab that appears after you delete the relationship. To do so, click Delete Field on the page bar.
Click Delete to confirm the action and return to the Relationships tab.
If you miss this opportunity for some reason, you can delete the reference field at any time within the detail table's Fields list.
Return to top
© 1999-2014 Intuit Inc. All rights reserved. Legal Notices.