Installation and New Features Guide (Windows)

ODBC import with FileMaker Pro 5-15
2. In the Select tab, click the table you’ll import from.
For this example, select the Salespeople table.
The columns associated with the Salespeople table appear.
3. Select a column to insert into your SQL query and click Insert into
SQL Query.
Select the
Salesperson ID column, then click Insert into SQL Query. This
moves the SQL statement into the SQL Query box.
4. Insert additional columns into the SQL query by double-clicking on
the column name.
Double-click the following columns: Salesperson, Sales_Manager, and
Sales_Region.
5. Click Execute to map the ODBC columns to FileMaker Pro fields.
The next section, “Importing ODBC data with a join” on page 5-17,
introduces the Where and the Order By tabs.
Note You can also type a SQL statement directly into the SQL
Query box.
SQL statement retrieves four columns from the Salespeople table
Specify the columns from each
table to insert into the SQL query
As you make choices in
each tab, the SQL query is
automatically generated
Click to add choices
into the SQL query
below
Click to begin the
SQL query