so difficulty level in works orders equates to oil change/transmission work - same as skill level in employees?
further questions
if a vehicle in for work of say oil change plus transmission work - so you would go for the higher skilled person to do oil change plus transmission work - or would you go for higher skilled person to do transmission work and lower skilled for the oil change? or to think of it another way, does only one person work on a vehicle? or do many work on a vehicle depending on skill level?
What about timing issues? key parts not in stock until noon, vehicle not available until 10am?
what about prioritising work? this vehicle must be finished before that vehicle?
Best I can guess is in vba/sql you would have something like two recordsets - one for the works orders ordered by difficulty level (high to low) and one for the employees in on the day (does not need to be ordered)
Code:
loop through the works orders
find next employee with right skill level - if not found move first and find next
assign employee to works order
next worksorder