I am trying to link two tables together, JOB & REPAIR. A JOB can either be a MOT, REPAIR or SERVICE. All jobs are populated in the JOB table under the JOB TYPE row (MOT, REPAIR, SERVICE) is selected through a list box. I want the query to show JOBTYPEs (FROM JOB TABLE) to the matching tables of either MOT, REPAIR or SERVICE.
In lamest terms if the JOBTYPE in the JOB TABLE is an MOT, MOT TABLE should be updated with this JOB...