About master/detail controls
If you expect users to work with large amounts of data on your form
For example, you can use a master/detail control when designing a human resources form that is connected to a database of employee records. The master control can display employee name and job title, and the details control can display employee location, hire date, date of birth, and so on. In database terms, this is the equivalent of a one-to-one relationship.
Similarly, you can use the master control to display one set of records (for example, customer names) and the details control to display related records (for example, customer orders). In database terms, this is the equivalent of a one-to-many relationship.
The master/detail relationship
A master/detail control is actually a set of two related controls. One of these controls is the designated master control; the other is the designated detail control. The master control is always a repeating table. The detail control can be either a repeating table or a repeating section. You can create the master/detail relationship by inserting the appropriate repeating controls on your form and then changing the properties of each control. Or, you can insert a predefined master/detail control from the Insert controls list in the Controls task pane.
When you insert a master/detail control from the Controls task pane, Microsoft Office InfoPath 2003 establishes a one-to-one relationship between the master control and the detail control. This means that each selected row in the master control has only a single matching result in the detail control. In a typical one-to-one relationship, both master and detail controls are bound to the same repeating group in the data source.
If you prefer, you can use key fields to establish a one-to-many relationship for a master/detail control. In this type of relationship, each selection in the master control can result in multiple matches in the detail control. For example, if users select a supplier record in a master control, they can view the products that are associated with that supplier in the detail control. In a typical one-to-many relationship, master and detail controls are bound to separate repeating groups in the data source
To establish a one-to-many relationship, you must use options on the Master/Detail tab to specify the appropriate key fields.
Note The information in this topic may not apply if you are working with a form designed using Microsoft Office InfoPath 2003 without the service pack installed. Learn more