Microsoft Office Tutorials and References
In Depth Information
Displaying related information with a subdatasheet
Displaying related information with a subdatasheet
Relationships are important to ensure data consistency. Access
has a feature that can automatically provide you with drilldown
capabilities to see the related data when viewing a datasheet.
We use a select query in this example to show you features
beyond the automatic settings. Details about how to create
these queries are described in Section 6, “Selecting data using
queries,” starting on page 95.
When viewed in design mode, a datasheet (which applies to
both a table and query), has a Subdatasheet property set either
to [None] (which switches off the feature) or to [Auto] (which
means that the relationships guide what is shown), or it can be
changed to refer explicitly to a table or query. In our example
we will use the query shown here as a subdatasheet.
4
1
2
3
Add a query as a subdatasheet to a table
1 In table design view, click Property Sheet to display the table
properties.
2 Select the query to use as a subdatasheet.
3 Provide the appropriate values for Link Child Fields and Link Master
Fields (linking key fields). If you have relationships, these might be
automatically completed for you.
4 Click View, and save your changes when prompted.
5 Expand the subdatasheet.
6 Click the Totals button.
7 Select a Sum total for the LinePrice column.
5
6
TIP A datasheet can display only one subdatasheet. If the
relationships imply that more than one subdatasheet could be
applied and the Subdatasheet property is set to [Auto], you will be
prompted to select which subdatasheet to use. The Access default
behavior for creating tables is to set the subdatasheet name property
to [Auto]. If you want to improve performance and not use this feature,
set this to [None].
7
Search JabSto ::




Custom Search