I want to sync a FM table ('A') with a MySQL table ('B') by using a script.
Table Occ. A has primary key 'recordid'.
Table Occ. B has primary key 'id' and also stores 'recordid' as a INT field.
This is what my script looks like (translated from Dutch)
Freeze Window Go To Layout ["_A" (A)] Execute Search Import Records ["myDb.fmp12"; Adjust Matching Records ;Mac Roman] Go To Layout [original layout]
I compare my two TO's based upon 'recordid', since that is matching in both tables.
For some reason, I always get a new record in my MySQL table.
What am I missing here??