Query Editor Fields
The following are descriptions of the fields in the Query Editor:
Tables List
Displays the names of tables available for inclusion in the report document. The tables you select appear as icons in the Query Definition pane.
Table Name
Indicates the name of the selected table
Alias
Specifies an optional alternate name of the table selected
Primary Master (M)
Specifies the primary master table of the query. Only one M table is permitted. Clicking the M button creates a primary Master-Detail relationship between the tables you have selected.
Secondary Master (m)
Specifies the secondary master table of the query. Multiple m tables are permitted (1:1 relationship with M table). Clicking the m button creates a secondary Master-Detail relationship between the tables you have selected.
Primary Detail (D)
Specifies the primary detail table of the query. Only one D table is permitted (1:N relationship with M table). Clicking the D button creates a primary Detail-Master relationship between the tables you have selected.
Secondary Detail (d)
Specifies the secondary detail table of the query. Multiple d tables are permitted (1:1 relationship with D table). Clicking the d button creates a secondary Detail-Master relationship between the tables you have selected.
Query Definition Pane
Displays icons representing the tables you have selected; relationships between tables are shown as labeled connectors. A “1” on the connector between two tables indicates a one-to-one relationship; an “N” indicates a one-to-many relationship.
Pattern
Defines a pattern-matching string to restrict the names of tables to be listed; for example, s% would retrieve only table names beginning with “s”
Table
Specifies the name of selected table and its owner