Syncing between FileMaker Pro and SQL Databases
I have created a SQL table to include a few of the fields in my FM database. I would like to update the SQL database as new records are added or existing records are modified in FileMaker. I have established the ODBC connection and the relationship between the 2 databases based on one record. I selected the box to create records in the SQL database when they are created on the FileMaker side but that does not seem to be working. What is the best way to update the SQL table with the latest data from FileMaker? Any help would be greatly appreciated.