AnsweredAssumed Answered

How can I script to set field of related records in a certain condition by using loop language?

Question asked by jiang_aq on Mar 5, 2017
Latest reply on Mar 5, 2017 by philmodjunk

For example:



Table 1:


Invoice     Paid Date

001           2/4

002           9/3

003           5/5



Table 2:


Invoice    Paid status

001          Paid

001          Paid      

002          Paid

003          Paid



if in Table1: for Invoice=001, I wanna change Paid date to "",  then in table 2(related with table 1), I wanna all Paid Status for invoice#001 change to "Unpaid" by using loop script, as have many related records, how can I do it?


Seems go to record command is just for local table, not for related table, right?