Work with Data from More Than One Table

Take advantage of the relationship that you create between tables to make data entry more efficient. For example, after you create a relationship between the Categories table and the Products table, you can create subforms (forms within a form) so that when you enter the name of a product category that is also a main form, such as Beverage, subforms show only the products in each subcategory. To create a form based on more than one table, click the New Object arrow, click Form, and then double-click Form Wizard. Follow the instructions in the wizard.

Next Steps