Help with Synchronizing Data Between Two Tables (Update Button)

[fribo]

Hello everyone,

I have developed a production downtime app where users can input various reasons for downtime that occur during production. The structure of the app is quite simple.

Table A:
- Key
- Name
- Downtime Reason 1
- Downtime Reason 2
- Downtime Reason 3
- Downtime Reason 4

Table B:
- Key
- RefKey
- Name
- Downtime Reason

Users can only make entries in Table A. When an entry is created, a bot triggers and adds one row in Table B for every downtime reason. Essentially, Table B contains the same information as Table A but has a different structure. All keys are UIDs, and the "RefKey" column is of type "Ref," referring to the key in Table A.

I noticed that when I enable the "is part of" checkbox for the "RefKey" column, it automatically deletes all referenced entries from Table B when I press the delete button on a row in Table A. This is exactly what I want. However, the same does not apply to the update button. When I press the update button, it changes the data in Table A but does not affect the data in Table B.

I have tried many things (actions, bots, disabling "is part of," and removing references). If anyone can help me find a solution to this problem, I would be very grateful!

Thank you so much in advance!