Accessing external data sourcesYou 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:
•
• add supplemental fields to ODBC tables to perform unstored calculations or to summarize data in the ODBC tables
•
•
• 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.
•
• You cannot modify the schema of external ODBC data sources using FileMaker Pro.
• If table names change in an ODBC data source, you can use the Manage Database dialog box to re-link to the ODBC table. See Restoring links to ODBC data sources.