Thank you in advance for your help and insights about this issue:
I have a parent table called db_rmas with a column named Manufacturer_Status, and child table called rma_updates referenced to the db_rmas with a column called Update. What I want to achieve is that anytime there is a new row in the child table the data from the column update make copies the same exact update in the Manufacturer_Status Column from parent table. This is what I have done so far but it is not working.
1. I created an action for the child table (rma_updates) to trigger another action to the referenced row
2. Then I created another action to set the values of the referenced child to table to the Manufacturer_status column in the parent Table:
FInally I created an automation so that anytime a row is updated from the child table (rma_updates), it may run a data action to run the Referenced action Update RMAs Status previously set in Actions:
After doing this, when creating a new record in the child table, the column manufacturer_status doesn't change at all.
If there is another way to do it, I appreacite your suggestions
User | Count |
---|---|
33 | |
11 | |
3 | |
2 | |
2 |