How to: Display Related Data on a Form

Data in separate tables can be related. When related data is in two tables, the relationship is visible in the Data Sources window. For example, if you connect to the sample Northwind database and expand the Products table, you will see that an Order Details table is displayed as part of the Products table. If you drag this Order Details table or one or more of its fields to a Windows Form, it is displayed as part of a relationship with the Products table. For example, if you scroll through the products in the Products table, the corresponding order information for each product is automatically displayed.