Insert or modify a subdatasheet in a table or query in an Access database

Note   You can use a table or query subdatasheet only in a Microsoft Access database, not a Microsoft Access project.

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.

Notes

• 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.
  
  
• 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 in the Northwind sample database. Open the Employees table, click Subdatasheet on the Insert menu, click the Tables tab, click the Employees table, click ReportsTo in the Link Child Fields box, and then click EmployeeID in the Link Child Fields box.