Update row value in a reference table after submit a form

[Wardaddy]

Hi All,

Need help on form submit action.

I have a form with reference data from another table, with dependent dropdown to ensure user select the correct job order number. Now, I need to update a row in the reference table to "Completed" once user submit the form. I tried create an action with Data:set the value of some columns > Set these columns > "Status" = Completed, but doesn't work. am I missing something ?