ACC: "Show Direct Relationships" Button Seems to Do Nothing

• Microsoft Access versions 2.0, 7.0

SYMPTOMS

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

When you click the Show Direct Relationships button, or click Show Direct on the Relationships menu while viewing the relationships in your database, nothing seems to happen.

CAUSE

Microsoft Access does not clear the Relationships window before displaying the direct relationships. Instead, Microsoft Access continues to display the current relationships, in addition to the direct relationships.

RESOLUTION

To view only the direct relationships for a table, follow these steps:

1. Click Clear Layout on the Edit menu in the Relationships window.

2. On the Relationships menu, click Show Table (or Add Table in version 2.0). Select the table whose relationships you want to see, click Add, and then click Close.

3. Click the Show Direct Relationships button on the toolbar, or click Show Direct on the Relationships menu.

MORE INFORMATION

To display all the table and query relationships defined in the database, click Show All on the Relationships menu.

You can save the layout you create in the Relationships window by choosing Save from the File menu (or Save Layout in version 2.0).

Users of a shared database can save individual layouts. Only one layout per user can be saved. If you save a layout in a shared database, your last saved layout will be overwritten.

REFERENCES