Question

What is the Combination of data form multiple related table into a single data sheet

Answer 1

Answer:

EXTRACT ANSWER :)

Explanation:

A subform is a form that is inserted in another form. The primary form is called the main form, and the form that is enclosed in form is called the subform. A form/subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form.

Subforms are especially effective when you want to show data from tables or queries that have a one-to-many relationship. 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. For example, you can create a form that displays employee data, and contains a subform that displays each employee's orders. The data in the Employees table is 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.