Define or edit a relationship between record sources in a data access page

If you add fields to the data access page and there isn't an existing relationship between the tables or queries they came from, Microsoft Access displays the Relationship Wizard. Relationships you define using the wizard apply only to the current data access page. They are not added to the database; therefore, they won't appear in the Relationships window in a Microsoft Access database or the database diagram window in a Microsoft Access project.

Define a relationship

1. In the Relationship Wizard dialog box, indicate which field you want to use to relate the record source to the data access page and the record sources that are currently part of the data access page's data definition.
2. Select the option that indicates the type of relationship you want between the two record sources.

Edit an existing relationship

1. If the data outline window is not displayed, click Data Outline on the View menu.
2. In the Data Outline window, locate the tables or queries whose relationship you want to edit. Look for entries with the page row source icon to their left.
3. Right-click the nested entry, and then click Relationships.
4. In the Relationship Wizard dialog box, indicate the fields that you want to use to relate the two objects.
5. Select the option that indicates the type of relationship you want between the two record sources.

Note   If a relationship type is unavailable at the bottom of the wizard dialog box, it means Microsoft Access determined that only one type of relationship is possible between the two record sources.