how do we update a record value in reference table once the current table record updated.
Case Details - Table
- Case ID Column
- Case Status Column
Work Order Details - Table
- Case ID Column (ref to Case Details -> Case ID)
- Work Order Status Column.
How do we change the status of case status column to closed when work order status set to closed.
Been figuring out the action, but not sure which one to use