- 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.
- Select the option that indicates the type of relationship you want between the two record sources.
Edit an existing relationship- If the data outline window is not displayed, click Data Outline on the View menu.
- 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. - Right-click the nested entry, and then click Relationships.
- In the Relationship Wizard dialog box, indicate the fields that you want to use to relate the two objects.
- 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.