Some forms use fields from multiple tables. One of the most common forms involves a one-to-many relationship between two tables. For example, an order form would include a single order date and customer, but the order might involve several different products. Thus there are two tables involved: an orders table with information about the order and a detailed orders table with data about the products purchased. The user should not have to enter the order date for each product. This can be avoided with a subform , a form embedded within a main form . The user enters the order date and other general information in the main form, and the individual products are listed in the subform. Access then stores the appropriate data in each table without the user being aware that multiple tables are involved.
Create a Subform