You can delete any relationship that has no dependent relations and no related fields referenced in either the current View or in an active computed field.
To delete a relationship, follow these steps:
| 1. | In the Relations dialog, right-click the relationship arrow and select Delete. |
| 2. | Analyzer deletes the relationship and the related table. |
You cannot delete a relation to a related table when the related table is also related to other tables. For example, in the diagram above, the relation from AR to Customer cannot be deleted until the relation from Customer to Sales_Reps is first removed. This is because the latter relation is dependant on the former relation.