Question on SET FIELD BY NAME
I have a simple script where I'm trying to copy a UUID-generated script value from a field in one table to it's currently-blank related field in another table. (The reason the field is blank in the related table is that I'm using an CSV file to populate the first table with 50,000 records).
When I try to run the script below, the target field does not get populated. The Script Debugger isn't helpful in seeing what's going on. The $ variable is being set correctly in each row of the initial table.
Here's the script. Any suggestions welcome! :)
Go To Layout Table1
Go to Record/Request/Page [First]
Set Variable [$var1; Value:Table1:id]
Set Field By Name[Table2::idFromTable1; $var1]
Go To Record/Request/Page [Next; Exit after last]
Why doesn't that work?
Thanks in advance.