How to Print and Delete Relationships in Access
Sometimes you may want to print a hard copy of the Relationships window or you may want to delete the relationship between two tables.
The Design contextual tab appears under Relationship Tools.
A report showing the tables and relationships appears in Print Preview mode.
If you want to modify the report before printing, click the Close Print Preview button and edit the report in Design View.
The Print dialog box appears.
The Relationships report is printed.
The report appears in Design View.
Access is very restrictive about letting you modify a related table, and often you must temporarily delete the relationship between two tables, modify one of the tables, and then re-connect them.
Here’s how to delete a table relationship.
Access asks you to confirm that you really want to delete the relationship.
Access deletes the relationship between the two tables.