How Do You 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. Close any open tables. Open the Database window (you can access it by hitting the F11 key). 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. Select Delete. Alternatively, while the line is selected, click Delete from the Edit menu. The relationship is deleted.
