Hi you all,
I have a table “jobs” and another one “stops” One job can have multiple stops. Both the job and the stops table have a status column. I want the job’s status to be automated in relation to stops status.
example: All the stops have the status " Planned"
- I want the job’s status to be “Planned” When I change the first stop to active, the job’s status to be active too.
just to test the functionality, I tried it this way:
What am I doing wrong?