how to delete/update a copied row in another table

[Gokul1]

when i add a row to table 1 , it gets copied to table 2 . when i delete/update a row in table 1 i want the same row to be deleted/updates in table 2. How do i do this? 

[Akshay_patel95]

Create an Action which will set data in the 2nd table from table 1. 

Create a bot for Update Event. Then select Run Action on Set of Rows. Select Table 2 as Referenced Table. And use a condition like SELECT(Table 2[Unique ID], [Unique ID] =[_THISROW].[ID]) as a referenced row. and select the action that you created. 

For Delete use above configuration. Just instead of Update use Delete Event and Action will be default delete action of Table 2.

[Gokul1]

How do i create an action for updating values in table two?

[Akshay_patel95]

This action is correct just use the column where you are collecting Table 1's ID in Table 2 as ref. So that you can refer to the table 1 using ref column in here.

[Gokul1]

i cant seem to get it to work. am i suppose to use the key in a select expression. eg..select(table 1[KG],[ID]=[_thisrow][ID])???