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. In order 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, QuickBase deletes all the data in the field.
To delete a field that is part of a relationship:
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.)
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 a field from the relationship.
Click the relationship that you want to edit.
QuickBase displays the Relationship Properties page, which lists fields that comprise 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.
Locate the field that you want to delete, and click its Del button.
Usage information for that field displays. Click the Delete this Field button.
Within the confirmation prompt that displays, click Delete.
Click Done to return to the Relationships tab.