cmj

Set Field / Replace Field in other table

Discussion created by cmj on Jul 22, 2017
Latest reply on Jul 23, 2017 by philmodjunk

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)

Else

Perform Script - to append existing values.

End If

 

Is this the correct approach? And what is the script command to append a field's value?

 

Thank You

Outcomes