I need to compare two copies of files to have a third one as result with all the latest records from both (based on timestamps).
The files consist of data from many tables brought together in one lay-out.
As a test to find the easiest way to accomplish what I want, I have exported (using the lay-out) three records from a testcopy.
Then changed data in these 3 records in the exported file (for test purpose).
I try to get these 3 records back imported using "Update existing records in found set", however this does not work: the target fields are greyed out even though the tables are related (see screenshot).
Changing "arrange by" to Custom Order doesn't make a difference.
Q1: what do I do wrong? And if it is not possible like this, why not?
Q2: if Q1 reply is not possible, then is the only way to go to make a script that replaces data table by table using
"Update existing records"?