I need to assign a list of 10 employees to vehicles on a daily basis.
Each vehicle can have multiple employees
Vehicles are then assigned to a work area
Each vehicle can be assigned to multiple work areas on any given day.
I want to create a form that lists the 10 employees and assign them to vehicles (also need to include absences)
I then need a second form that details vehicles work areas.
This seems simple but I cannot get my head around it as there are 3 levels; employee, vehicle and work area for each date; each vehicle can have multiple employees and work areas.
Any suggestions about table design, links and queries would be greatly appreciated.
Thanks
Alan