Insert or modify a subdatasheet

1. Open a table or query in Datasheet view.
2. On the Insert menu, click Subdatasheet.
3. Click the Tables, Queries, or Both tab, depending on which kind of object you want to insert as a subdatasheet.
4. Click a table or query in the list.
5. In the Link Child Fields box, click the field to be the foreign key or matching field for the table or query that is the subdatasheet you chose in step 4.
6. In the Link Master Fields box, click the field to be the primary key or matching field for the table or query that is the main datasheet you opened in step 1.

Note   If you want to specify two or more fields in the Link Child Fields or Link Master Fields box, enter the field names separated by a semicolon (;) ù for example, Last Name;First Name.

Tip

You can create a self-join when you insert or modify a subdatasheet. For example, suppose you want to see the employees who report to each manager as a subdatasheet of the Employees table. Open the Employees table, click Subdatasheet on the Insert menu, click the Tables tab, and click the Employees table. Then click ReportsTo in the Link Child Fields box, and click EmployeeID in the Link Master Fields box.