I want to know when something is incomplete and what makes it incomplete. I've been at this for over a week with no luck.
i.e. Mechanic is supposed to check 12 components on every car he works on. Each check creates a new row of data in the table. I'm working with one table for all mechanics and all cars (cannot be changed).
I want to know every car he/she did not perform all 12 checks on. I want to know what was missed for each car.
Can I do this?
Thank you in advance!