Databases Reference
In-Depth Information
4.
Now, navigate to the
Fields
tab and, from the
Available Fields
list on the
left, highlight the
Year
field as well as the
Aircraft Type
field, and click on
the
Add >
button. Then, click on
OK
and two new listboxes will be created.
5.
We will now create a
Table Box
, so right-click on the workspace area again,
but this time select
New Sheet Object | Table Box…
, as seen here:
6. From the
New Table Box
window, enter
Flights
in the
Title
box.
7. Then highlight the following fields from the
Available Fields
list and click
on the
Add >
button:
%Aircraft Type ID
,
# Air Time
,
# Available Seats
,
# Departures Performed
, and
# Departures Scheduled
.
Remember to press the
Ctrl
key to highlight multiple fields at once.
8. Click on
OK
.
9. Right-click on the
Year
listbox and click on
Select All
. Notice that, by
association, this reduces the aircraft types list and keeps only those that have
logged flights in
2009
,
2010
, and
2011
(the selected years).
10. Now, right-click on the
Aircraft Type
listbox and click on
Select Excluded
from the pop-up menu. This will switch our selection to those aircrafts that
have not logged flights.