I'm writing a simple app that needs to update some data from an ODBC source.
I have the same table in a MySQL database and the FileMaker app. I want to write a script that will run through all records in one table and compare them to the records in the other table. If there is a difference between them, show a dialog and let the user choose to copy the new information into the FileMaker record.
I've got the ODBC and external data source part working and I have the tables visible in FileMaker (ESS). Looping over all records is easy, but I can't figure out how to find the identical record in the ODBC source via its primary key.
The tables are absolutely identical except for where they are stored. Same data fields, etc. and in most cases 99% of the data will be identical.
If you are able to add the MySQL table as an external data source in Filemaker, you should be able to define a relationship between the two tables matching on the primary key field.
Once you have done that, you can access the corresponding record's data directly through the relationship.