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?

Outcomes