A subdatasheet is useful when you want to see the information from several data sources in a single datasheet view. For example, in the Northwind sample database, the Orders table has a one-to-many relationship with the Order Details table as shown in picture 1 below:


Picture 1: Relationship between the Order Details and Orders Tables

If the Order Details table is added as a subdatasheet in the Orders table, you can view and edit data such as the products included in a specific order (each row) by opening the subdatasheet for that Order. Picture 2 shows this scenario:


Picture 2: Relationship between the Order Details and Orders Tables

In this video tutorial, you will learn how to create queries and link them as subdatasheets. You will also learn how to aggregate the order details so that you can view the consolidated data for each employee.