Help

Table Of Contents

Accessing external data sources

ILEMAKER PRO HELP 558

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.

Using supplemental fields

If your FileMaker Pro file accesses data from an ODBC data source, you can use supplemental

fields to define unstored calculations or summary instructions that act on data coming from the

external sources. These fields display calculation and summary results in the FileMaker Pro file

without changing the external database. For example, you can use supplemental fields to display

aggregated data from an external file similarly to how you use summary fields to display aggregated

data stored in FileMaker

Pro files.

To do calculations on ODBC data:

1. Open the file with the link to the external data source.

2. Choose File menu > Manage > Database.

3. In the Manage Database dialog box, click the Fields tab.

4. Choose the ODBC table you want to work with from the Table list.

5. Add a calculation field or a summary field.

See Defining calculation fields and Defining summary fields for more information.

6. Specify the fields in the ODBC table for which you want to calculate or summarize values.

The supplemental fields appear in the Fields tab for the specified ODBC table.