ACC2002: Working with Subdatasheets in Microsoft Access (304276)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q304276
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SUMMARY

In a subdatasheet, you can view and edit related or joined data in a table or a query, in a form datasheet, or in a subform. For example, in the Northwind sample database, the Suppliers table has a one-to-many relationship with the Products table; therefore, for each row of the Suppliers table in Datasheet view, you can view and edit the related rows of the Products table in a subdatasheet.

MORE INFORMATION

To Insert a Subdatasheet

  1. Start Microsoft Access, and then open the database that you are working with.
  2. Open a table or a query in Datasheet view.
  3. On the Insert menu, click Subdatasheet.
  4. Click the Tables, the Queries, or the Both tab, depending on which kind of object you want to insert as a subdatasheet.
  5. Select a table or query in the list.
  6. 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 that you chose in step 5. For example, if you wanted to create a subdatasheet to view related Orders for each Customer record, choose the Customer field in the Orders table.
  7. In the Link Master Fields box, choose the field to be the primary key or matching field for the table or query that is the main datasheet that you opened in step 2.

To Remove a Subdatasheet

  1. Open the table or query that contains the subdatasheet in Datasheet view.
  2. On the Format menu, point to Subdatasheet, and then click Remove. NOTE: Removing a subdatasheet does not delete the table or query, nor does it modify any relationship.

REFERENCES

For additional information about working with subdatasheets in Microsoft Access, view the Microsoft Access 2002 Help documentation at the following Microsoft Web site:

About Subdatasheets

For additional information about finding the Northwind sample database, click the article number below to view the article in the Microsoft Knowledge Base:

276376 Where Are the Northwind Sample Files?

Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbhowto KB304276
©2003 Microsoft Corporation. All rights reserved.