Progress
Results User’s Guide
for Windows
Using Master and Detail Sections to Display Records
When you create a query that contains more than one table, Results automatically displays all the fields from the tables in one section. To help you analyze data, you can separate the information contained in these tables into two sections, called Master and Detail.
For example, if your query uses fields from the Customer, Order, and Order-Line tables to list the items each customer ordered, Results places the records in one section by default, as in the following example:
![]()
In this example, the query retrieves a record for each item number within each order. Many of the records contain identical information. To reduce the amount of repetitive information displayed in the view, you can split the view into two sections, Master and Detail. A Master section begins a new order and its corresponding Detail section contains the specific items ordered. You can use the Master-Detail option with the Browse, Report, and Form query views.
Splitting composite records into Master and Detail sections does not alter the way in which the query retrieves the records. It simply alters the way in which Results displays the records within the query view:
![]()
In this example, the Master section contains fields from the Customer and Order tables and the Detail section contains fields from the Order-Line table.
Follow these steps to split composite records into Master and Detail sections:
- Choose Options
Master-Detail. The Master-Detail dialog box appears:
![]()
- Determine how you want to split the tables, then select a break point and choose OK.
When you split composite records into Master and Detail sections the Form or Browse views, Results automatically places each section in its own frame. See the "Browse View" and "Form View" sections in "Using Query Views," for more information about frames.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |