Restoring links to ODBC data sources
If one or more table names have changed in an
ODBC data source, you can use the Manage Database dialog box to update links between a FileMaker file and the external SQL data source (ESS).
To update links to ODBC data sources:
1. Choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Tables tab.
FileMaker displays tables from the ODBC table in italics. If a table name has been changed in the ODBC data source, <Table Missing> appears in the Details column and a Re-link button appears in the Manage Database dialog box.
3. Select the missing table.
4. Click Re-link.
5. In the Specify Table dialog box, select the renamed table and click OK.
If field names in the ODBC table have changed or are missing, you must synchronize the field schema. For more information, see
Updating data between FileMaker and ODBC data sources.
Notes
•Re-linking does not validate or re-specify primary keys.
•If no fields in the re-linked table match, FileMaker Pro displays an error message allowing you to continue or terminate the re-linking process.
•You can narrow the list of tables displayed by setting a filter in the ODBC tab in the Edit Data Source dialog box. For more information, see
Editing ODBC data sources.