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

Chapter 11. Creating Multitable and Cros... > Adding Subdatasheets to a Table or Q...

Adding Subdatasheets to a Table or Query

Subdatasheets are closely related to lookup fields, but serve a different purpose. Subdatasheets display related table values in an embedded datasheet, whereas lookup fields display base table values in a combo box or list box. Both of these Access features depend on the equivalent of one-to-many queries; the difference between the queries is that the many side of a subdatasheet is a related table, whereas a lookup field uses a query against a base table to supply the many side values.

You also can cascade subdatasheets to display related data of multiple joined tables, a feature not applicable to lookup fields, but a table or query can't have more than one subdatasheet. Figure 11.31 illustrates the Customers table displaying the Orders subdatasheet for Alfreds Futterkiste with embedded sub-subdatasheets that display Order Details records.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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