I have 2 tables a Job table and a Log table. When an employee checks into a Job initially a row is added to the Log table. Multiple employees can check into the same job. When an employee checks out (from the Job table) I need the related Log table row to be updated to “Checked Out”.
I have a column on the Log table that references the Job table which created a “Related Log” list.
I have a “Check Out” action button for the Job table that changes the Job table status and an action on the Job table to execute and action on a set of rows but can’t, after many hours of trying, figure out how to change the status on the related Log table. I don’t know if I’m using an incorrect reference the the action or if its a workflow issue. I read the support articles on workflows and references and still can’t make it work.