These instructions apply to Access 97. Close any open tables. Click the Query tab. From the Query window, click the Relationship button in the toolbar or select Relationships from the Tools menu. A window appears.
Rectangular shapes joined by lines appear.
Each rectangle represents a table, and the lines represent relationships between tables. Click on the line that represents the relationship you want to delete. Right-click to obtain a menu. Alternatively, while the line is selected, click Delete from the Edit menu. The relationship is deleted.