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.
User | Count |
---|---|
18 | |
9 | |
8 | |
6 | |
5 |