A relationship between tables can involve many different fields. 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, Quickbase deletes all the data in the field.
To delete a field that is part of a table-to-table relationship:
Open the app that contains the relationship you want to to edit.
If you created a relationship between tables in two different apps (a cross-app relationship), open the application that contains the child table.
Open the table.
Select Settings, then click Table-to-table relationships.
Select the relationship that you want to edit. The relationship properties appear.
Locate the field that you want to delete, and select the Del button. Usage information for that field displays.
Select Delete Field in top right. A Delete this field dialog appears.
Select the Delete button.