To make the structure of a multiple-line basic list clearer, you want to generate a list showing the following information for each flight connection; the actual flights, the date, the price, and information about occupied and free seats.
You have created query G1 as described in the section on
defining single-line basic lists
,
and created the G2 copy as described in the section on
determining the sort sequence
.
Create a copy of the G2 query, and call it G5.
Highlight the G5 query and click on the
Change
function.
Create a new note.
On the
Field-Group Selection
screen in the
Field Selection
series of screens, select the additional
Flight
Table
field group. In the next
Field Selection
screen, select the fields that contain the required information about the flights. You can see these fields in the screen shown below.
Click on the
Basic List
option to determine the lines that are displayed.
The
Basic List Row Structure
screen is displayed.
Type the appropriate information into the fields as shown in the above diagram.
In this basic list, two different lines are defined. This means that the list is a two-line basic list.
Since the basic list has two lines, you deactivate the
Columns separated by
|,
checkbox.
On the
Control Levels
screen, select the
Frame
column for the
Departure Time
control level to frame each individual flight connection
Use the
Test
function to test the query.
When you have made your selections on the selection screen, the following list is displayed:
This list is still not adequate. You want a flight connection to be displayed only if there are flights during the selected period.
Click on the
Back
button to return to the
Basic Lists
series of screens.
Use the
and
functions to navigate to the
List Line
Display Options
screen.
In the
Ref.
column, specify which of the other lines you want the current line to displayed with.
Since the flight connections (line 1) are only meant to be displayed in connection with the flights (line 2), you must type
2
for line 1 in the
Ref
. column.
Specifying a reference line in the
Ref
. column means that your list contains only those flight connections for which flights actually exist in the selected period.
To display the price of a flight in the relevant currency, you must set the appropriate radio button for the field
Price
in the column
Unit
on the
Field Output Options
screen.
Activate the
Page Header
checkbox for the first line.
The
Page Header
option is useful only if you are defining your query with a fixed page size or you want to print your query lists. This option allows you to repeat certain lines in every page header.
In the list for each flight connection (line 1) there are several flights (line 2). This means that if you are working with a fixed page size (which is always the case if you are going to print the list) one page may contain only lines with flights. However, if you select the
Page Header
column for line 1 (flight connection information), the line containing the flight connection is displayed on each new page. On each page you are therefore able to see to which flight connection the flights on each page belong.
Use the
Test
function to test the query again.