AnsweredAssumed Answered

Scripting problem

Question asked by mz5005 on Jul 18, 2016
Latest reply on Jul 21, 2016 by mz5005

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.