Hi ,
I am very new to access and I have made a database for a small wedding car hire firm as an assignment for college. The database works fine , I can add my customers , staff , vehicles etc.. and make orders ok but I have some criteria I need to meet running through criteria A-Q
I have met all options except for D and K
which I guess are the hardest ones of the bunch
D) is produce a list of available vehicles and drivers for a given input date.
This relies directly on K) working as far as I can tell as once k is done this should be simple.
K) is search for an availability that satisfies a customers criteria for example is a car available on a certain date.
this is made more tricky as if a vehicle has already been booked for the date I am searching on then it has to return a negative result e.g this vehicle is booked on this date,also if a driver is on holiday on this date I have to again return a negative.
I have made a form whereby the user can make their order , choose the car they want and the company can then assign a driver to the order.
the form has an order date and simple combo boxes with driver names in and vehicle names , probably not the best way especially for expansion , but I only want to pass the final criteria and get on with my final assignment which has a higher grading weighting.
once I select a vehicle for the customer I assume there has to be some kind of a process probably to do with the after update command such as if the vehicle has already got a booking on this date then return a negative message else book this vehicle on this date for this order.
the same pretty much for the drivers , though it would be if the booking date is between the drivers holidays start and finish then return a negative else book this driver on this day.
I am not altogether sure of the process involved in the check and also if a driver and vehicle are booked for a date e.g 01/01/2007 how I can prevent double booking etc..
at the moment for example I can have Driver1 and Vehicle1 Booked 4 times on the same day. even though Driver1 is on holiday and vehicle1 is booked already
I took it into college to be checked but our usual tutor is off having a baby and the back up one isnt much help (far too busy etc.)
so im trying to sort it alone.
any advice would be ace thanks.
I am very new to access and I have made a database for a small wedding car hire firm as an assignment for college. The database works fine , I can add my customers , staff , vehicles etc.. and make orders ok but I have some criteria I need to meet running through criteria A-Q
I have met all options except for D and K
which I guess are the hardest ones of the bunch
D) is produce a list of available vehicles and drivers for a given input date.
This relies directly on K) working as far as I can tell as once k is done this should be simple.
K) is search for an availability that satisfies a customers criteria for example is a car available on a certain date.
this is made more tricky as if a vehicle has already been booked for the date I am searching on then it has to return a negative result e.g this vehicle is booked on this date,also if a driver is on holiday on this date I have to again return a negative.
I have made a form whereby the user can make their order , choose the car they want and the company can then assign a driver to the order.
the form has an order date and simple combo boxes with driver names in and vehicle names , probably not the best way especially for expansion , but I only want to pass the final criteria and get on with my final assignment which has a higher grading weighting.
once I select a vehicle for the customer I assume there has to be some kind of a process probably to do with the after update command such as if the vehicle has already got a booking on this date then return a negative message else book this vehicle on this date for this order.
the same pretty much for the drivers , though it would be if the booking date is between the drivers holidays start and finish then return a negative else book this driver on this day.
I am not altogether sure of the process involved in the check and also if a driver and vehicle are booked for a date e.g 01/01/2007 how I can prevent double booking etc..
at the moment for example I can have Driver1 and Vehicle1 Booked 4 times on the same day. even though Driver1 is on holiday and vehicle1 is booked already
I took it into college to be checked but our usual tutor is off having a baby and the back up one isnt much help (far too busy etc.)
so im trying to sort it alone.
any advice would be ace thanks.
