• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Access 2000 for Access 95 and... > Viewing and Editing Related Records ...

Viewing and Editing Related Records in Subdatasheets

Subdatasheets are a new Access 2000 feature that let you view and edit related records of Jet tables or queries within a single datasheet. For tables, the subdatasheet uses Relationships window data to determine the subordinate records to display; a subdatasheet based on a query uses join information. Clicking the boxed + symbol opens the first-tier subdatasheet; if more tiers of data exist, you can open nested subdatasheets. Figure 1.12 shows Northwind.mdb's Customers tables with related Order Details records nested within the Orders subdatasheet.

Figure 1.12. Northwind's Customers table displaying related Orders and Order Details records in nested subdatasheets.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint