I have been using Filemaker for many years (V3.xx onwards) but have never come across the Let and Evaluate functions.
I need to patch up a legacy database for a client (which is why I need to stick with repeating fields for this question) and I would like to copy the contents of certain repeating fields from one table to another.
There are 24 repetitions and 3 fields.
I can see that I can use 3 groups of 24 set field statements to achieve this but was wondering if I could use a loop and somehow create the command that I want to execute for each repetition by using the evaluate / let functions.
Am I even close or shall I stick with the 72 set field statements?