I am getting some strange results when trying to use ExecuteSQL to populate merge variables on my layout.
I am using a text field with a let statement in a conditional formatting calculation to assign data to my variables, but it seems that the ExecuteSQL statements aren't always executing.
To confirm that it wasn't something specific to my database I downloaded John Ahn's dynamic value list demo which is using the same technique:
I went to the ID_Values layout, and as I navigate through the records the data on the screen does NOT refresh correctly.
If I go to Records - Refresh Window it fixes up the current record, but when I navigate to the next record it will be wrong again.
I am on record 1 which shows:
I then navigate to record 2 (Note that the ID's on the right side have changed but the names have not) which shows:
Then I refresh the window and it shows:
I am running FileMaker Pro Advanced 12.0v2
I have tried this on both a PC running Windows 7 and a Mac running OS X 10.6.8
Is anyone else experiencing this issue or has anyone found a fix?