Page
|
|
|
Next Page |
|
| Contents > Accessing external data sources > Accessing external data sources |
|
|
| Accessing external data sources |
| You can connect to and work with data in external data sources in much the same way that you work with data in the current, active FileMaker file. For example, you can: |
 |
create tables in the relationships graph for external FileMaker files and ODBC data sources |
|
work with data from external files in FileMaker fields and layouts |
|
add supplemental fields to ODBC tables in order to perform unstored calculations or to summarize data in the ODBC tables |
|
add, change, and delete external data interactively |
|
create relationships between fields in FileMaker tables and fields (also called "columns") in ODBC tables |
|
construct SQL queries for importing via ODBC. See Querying an ODBC data source from FileMaker Pro. |
| Notes |
|
There are other ways to link with ODBC data sources besides using FileMaker Pro as an ODBC client application. You can write SQL queries to use FileMaker Pro as a data source. See Sharing FileMaker Pro data via ODBC or JDBC and FileMaker ODBC and JDBC Guide for more information. |
|
For an overview of the various ways of working with ODBC data sources, see Using ODBC and JDBC with FileMaker Pro. |
|
You cannot modify the schema of external ODBC data sources using FileMaker Pro. |
| More detail about accessing external data sources |
|
Configuring an ODBC client driver |
|
Connecting to data sources |
|
Working with data sources |
|
Adding tables to the relationships graph |
|
|
| Contents > Accessing external data sources > Accessing external data sources |
|
|
Next Page |
|