How to Delete a Relationship in Microsoft Access

Relationships that are no longer needed, or that were entered in error, can be deleted in Microsoft Access. These instructions apply to Access 97.

Things You'll Need

• Microsoft Access

Instructions

1. Close any open tables.

2. Open the Database window (you can access it by hitting the F11 key).

3. Click the Query tab.

4. From the Query window, click the Relationship button in the toolbar or select Relationships from the Tools menu.

5. A window appears. Rectangular shapes joined by lines appear. Each rectangle represents a table, and the lines represent relationships between tables.

6. Click on the line that represents the relationship you want to delete.

7. Right-click to obtain a menu. Select Delete. Alternatively, while the line is selected, click Delete from the Edit menu. The relationship is deleted.

Tips & Warnings

• Once selected, the relationship line will turn bold.

• If the table you want doesn't appear, click the Show Table button in the toolbar, then select the table you want to use.

• If you just want to change the relationship, it's easier to edit it than to delete it and create it again. See "How to Edit an Existing Relationship in Microsoft Access."