The main form and subform in this kind of form are linked so that the subform displays only records that are related to the current record in the main form. The subform shows data from the 'many' side of the relationship.

The main form shows data from the 'one' side of the relationship.Ģ. The data in the Orders table is the 'many' side of the relationship - each employee can have more than one order.ġ. The data in the Employees table is the 'one' side of the relationship. For example, you can create a form that displays employee data, and contains a subform that displays each employee's orders.

A one-to-many relationship is an association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table. Subforms are especially effective when you want to show data from tables or queries that have a one-to-many relationship. A form/subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form. The primary form is called the main form, and the form that is enclosed in form is called the subform. Open a subform in a new window in Design viewĪdd related data to a form without creating a subformĪ subform is a form that is inserted in another form. What do you want to do?Ĭreate a form that contains a subform by using the Form WizardĪdd one or more subforms to an existing form by using the SubForm WizardĬreate a subform by dragging one form onto another Subforms are a convenient tool for doing this, and Access provides several ways to help you create subforms quickly. For example, you might want to see customer data from one table and information about customer orders from another table at the same time. When you are working with relational data (related data that is stored in separate tables), you often need to view multiple tables or queries on the same form.

Microsoft access 2013 tutorial 5 cases