Article ID: 278392 - View products that this article applies to.
This article was previously published under Q278392
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).
When you use the expand indicator (+) in Datasheet view to display related records in a subdatasheet, the fields from those records are not available for selection if you switch to Pivot Table or Pivot Chart view.
You can include fields from both tables by creating a query, a function, a view, or a stored procedure that joins the related tables, and then design the pivot table or pivot chart from that query.
To include fields from the Products table as well as from the Orders table in a Pivot Table view in the Northwind.mdb sample database, follow these steps.
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
When you are working with a table in Datasheet view, you can use the expand indicator to display a subdatasheet that shows the records in a related table.
You can also work with the table in Pivot Table view so that you can create a cross-tab-type presentation of the table data, but the field list for the Pivot Table view does not include fields from the related table. This also occurs if you are working with Pivot Chart view.
Steps to Reproduce the Behavior