I'm using FM 12 Advanced.
I have a script that writes a new record into table 2 when I leave a portal row based on table 1.
That works fine.
However, after the record is initially made in table 2, I don't wish to keep adding more records into table 2 every time I leave the portal row.
Instead, I only want to update the values in table 2 (i.e. just write over existing values) when I leave the portal row after the initial record exists.
I'm guessing that I need to see if a specific record exists and then determine if I create a new record or append the existing.
If (field 1 ="", Perform Script - add record)
Perform Script - to append existing values.
Is this the correct approach? And what is the script command to append a field's value?