Data update between 3 tables with bot

[Pointer]

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.

[MultiTech]

With moving data between tables, it's all about having three parts:

1. The data you need, present on the level (or connected via references so you can deref it)
2. An action to execute the data change (on the level where the change needs to happen)
3. An action to execute #2's action on a set of rows

Context is key - and I don't mean CONTEXT() the formula/function.

I mean TABLE context - as in, I'm on the "Orders" table and need to pull data from the "Order_Details" table... so your table context would be "Orders".  In order to get the data from another table, you need to be able to access that piece of data from that specific level - this is where references come in.

As long as you can access the bit of data you want, then it's just a matter of creating the actions necessary to accomplish the various data changes.

[Pointer]

I can change data between two tables. But I want to update without reference between two tables which are common child tables, is it possible?

SELECT(Table3[ID],IN([_THISROW].[table1ID],[Related childrecord][table1ID])) this formula did not work

[MultiTech]

If they're common child tables, then they share a reference. It's all about following the references.

Check out chaining dereferences in the documentation