I have a scripting problem of which I hink the solution will be very simple,
but I just don't see it.
There are 2 tables, A and B.
Script X checks per records from table A in table B if the record exists.
If so, it will trigger script Y to overwrite some data of that record (SET FIELDs).
So far so good - all data updated correctly.
However, when the record from table A does not exist in B, then it adds a new record
in B and after triggers again script Y. What happens is that a new record is added successfully but no data is filled.
I have the idea it might have got to do with the record pointer, so tried to add GO TO RELATED
RECORD and also GO TO RECORD <last>, but it doesn't change anything.
Screen shots of script X and Y attached (script X only look at "status 3").
Any help greatly appreciated... wasted almost a day on this already.