Data update between 3 tables with bot

Table 1(main 1)

        Table 2 (child)

Table 3 (main 2)

        Table 2 (child)

How can I update table 3 with bot using the values in table 2 according to the change I will make in this table? 

SELECT(Table 3[ID], [ID]=[_THISROW].[ID])

I can update with bot using reference action between table 2 and table 3. What I want is to update table 3 according to the data in table 2 when there is a change in table 1.

SELECT(Table3[ID],IN([_THISROW].[table1ID],[Related childrecord][table1ID]))I tried that but it didn't work.

 

Thanks.

0 3 109
3 REPLIES 3
Top Labels in this Space