Import from ODBC Source

[Jaren Meier]

I am trying to figure out a way to have a FMP database use a script to check for updates or changes to the ODBC database before it does its import script. What would be the solution to only update the records that have the changes from the ODBC database? Is this possible? I can currently import the 12,000+ records into the FMP database, but takes a while.

[mr_vodka]

I tend to use a modification timestamp in the external data and adjust the SQL statement accordingly.