Help

Accessing external data sources
F
ILEMAKER PRO HELP 551
The Open File dialog box appears.
5. Select a FileMaker file to add to the path list.
6. Click Open to add the path for this file to the file path list.
Each named FileMaker data source can consist of one or more file paths. Use multiple file paths
when you want FileMaker
Pro to search a list of potential files. See Creating file paths.
You can also enter file paths by typing them directly into the file path list. Each file path must
appear on a separate line.
7. Click OK to save the data source.
Named data sources appear in creation order in the Manage External Data Sources dialog box.
You can choose to view the names by alphabetical or custom order.
Type indicates whether the data source is a FileMaker or ODBC data source. File paths are
listed under Details.
Note Alternatively, you can choose the Relationships tab in the Manage Database dialog box and
click
. In the Specify Table dialog box, for Data Source, choose Add FileMaker Data Source.
See Adding tables to the relationships graph.
For details on working with FileMaker data sources, see Editing external FileMaker data sources.
To add an ODBC data source:
Important Before creating a SQL data source, you must connect to the external data source via an
ODBC
driver and set up DSNs. See Configuring an ODBC client driver.
1. With the FileMaker database open, choose File menu > Manage > External Data Sources.
The Manage External Data Sources dialog box appears.
2. Click New.
The Edit Data Source dialog box appears.
3. For Type, select ODBC.
4. Enter a name for the data source.
Names cannot be over 100 characters long.
5. For DSN, click Specify.
6. In the Select ODBC Data Source dialog box, select the System DSN that you want to work
with from this FileMaker file.
7. Set other options. For details on working with ODBC data sources, see Editing ODBC data
sources.
8. Click OK.
The data source is now listed in the Manage External Data Sources dialog box.
Note Alternatively, you can choose the Relationships tab in the Manage Database dialog box and
click
. In the Specify Table dialog box, for Data Source, choose Add ODBC Data Source. See
Adding tables to the relationships graph.
To delete an external data source:
1. In the Manage External Data Sources dialog box, select the data source in the list.
2. Click Delete.