Databases Reference
In-Depth Information
5.
Complete the
Table File Wizard
window by clicking on
Finish
.
6.
Replace the
Directory;
text with
[Aircraft Types 2010]:
to assign that
name to the table.
7.
If you did not turn on automatic saving, save the document by selecting
File
| Save Entire Document
from the menu or by pressing
Ctrl + S
.
The resulting script should look like this:
[Aircraft Types 2010]:
LOAD AC_TYPEID as [%Aircraft Type ID],
AC_GROUPNAME,
SSD_NAME as [Aircraft Name],
MANUFACTURER as [Aircraft Manufacturer],
LONG_NAME as [Aircraft Name Full],
SHORT_NAME as [Aircraft Name Abbreviated],
BEGIN_DATE as [Aircraft Begin Date],
END_DATE as [Aircraft End Date]
FROM
[..\Data Files\CSVs\Aircraft_2010_Update.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
8. Reload the document by selecting
File | Reload
from the menu, or by
pressing
Ctrl + R
.
9. Once the script is finished, click on
OK
to close the
Sheet Properties
[Dashboard]
dialog.
10. Add the fields
AC_GROUPNAME
and
Aircraft Begin Date
to the
Aircraft
multibox.
When we interact with the
Aircraft
multibox, we notice that something strange
is going on. There are three fields with overlapping information.
AC_GROUPNAME
contains information that is also shown in the
Engine Type
and
Number of
Engines
drop-down lists. When we interact with the data, we will notice that any
aircraft that has an
Aircraft Begin Date
field before 2010 is associated with the
Engine Type
and
Number of Engines
fields, while later models are associated
with the
AC_GROUPNAME
field.