Microsoft KB Archive/304470

= ACC2000: How to View and Edit Relationships in a Microsoft Access Database =

Article ID: 304470

Article Last Modified on 8/9/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q304470



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2002 version of this article, see 304469.



SUMMARY
This article shows you how to view and edit relationships in a Microsoft Access database.



Viewing Existing Relationships
To view existing relationships, follow these steps:  Press F11 to switch to the Database window. On the Tools menu, click Relationships. Do one of the following.

To view all the relationships defined in the database:

 On the Relationships menu, click Show All.

To view the relationships defined for a particular table:

 Click the table, and then on the Relationships menu, click Show Direct.</li></ul>

To view only the relationships defined for one table without viewing the relationships defined for other tables:

 On the Edit menu click Clear Layout to remove all tables from the Relationships window (this will not delete the tables or the relationships; it just removes them from the Relationships window).</li> To add the table back, on the Relationships menu, click Show Table, double-click the table, and then click Close.</li> On the Relationships menu, click Show Direct.</li></ul> </li></ol>

Editing an Existing Relationship
To edit an existing relationship, follow these steps:
 * 1) Close any tables that you have open. You cannot modify relationships between open tables.
 * 2) Press F11 to switch to the Database window.
 * 3) On the Tools menu, click Relationships.
 * 4) If the tables whose relationship you want to edit are not displayed, click Show Table on the Relationships menu, and then double-click each table that you want to add.
 * 5) Double-click the relationship line for the relationship that you want to edit.
 * 6) Set the relationship options. If you need information about a specific item in the Edit Relationships dialog box, click the question mark button, and then click the item.

For additional information about defining relationships in Microsoft Access, click the article number below to view the article in the Microsoft Knowledge Base:

304467 ACC2000: Defining Relationships Between Tables in a Microsoft Access Database

<div class="references_section">