I am trying to create an Access database which will allow me to store customer details, vehicle and driver details and create jobs from it.
My problem is that I can't get the job query to work. In order to book a vehicle, the user has to specify the colour, number of passengers, times and dates etc. However, most of the drivers work part time so only work a few hours during the week. They also can drive certain vehicles according to their driver's license. I need to some how match the right driver up to the right vehicle for the right job making sure it is all available (driver and vehicle).
Any ideas on how to go about this. Sorry if this is not clear, but it is beginning to look like a complex database!
Currently I have 5 tables; Customers, jobs, vehicles, drivers and license. The license table is a look up table for the license type field in the driver and vehicle table. The queries are the problem as I need it to perform the tasks outlined above.