Data Integration

Question 1

What are three things you can do with a shadow table, including its fields and records?

Answer 1

Here is what you can and cannot do with the fields and records in an ODBC data source:

a. Can do
i. Display the data on FileMaker layouts
ii. Add unstored calculation fields to perform calculations on the ODBC data.
iii. Add summary fields to summarize the data in the ODBC source
iv. Add, change, delete external data if your permissions in the ODBC source all it.
v. Create relationships between fields in FileMaker and the ODBC fields (or columns).
vi. Specify the primary key of an ODBC table (this process is done during the set up of the ODBC
source) .
vii. Use the records in value lists.

Question 2

What are three things you cannot do with a shadow table?

Answer 2

Cannot do

i. Add additional text, number, date fields to the table inside FileMaker.
ii. Change the schema of the ODBC data source.
iii. Make use of field indexes.