I have 2 tables. One table contains a list of machines. Each machine has a status, for example AVAILABLE, ALLOCATED, IN USE, IN REPAIR. Each machine has a unique ID number.
The second table contains a list of jobs, and the machine type required for the job. The mechanics need to assign a machine, unique ID number, to each job.
If the mechanics assign the Unique ID number of a machine to a job, how can I trigger an update in the Machine table to change the status of that specific machine from AVAILABLE to ALLOCATED?