I am in the military and am trying to design a database for my platoon that can help track our missions and vehicles. I have a general idea in my head on how I would like it to work, I'm just having issues on how to translate it into Access and get it to work. I have a table that contains all of the vehicle & trailer information. I have another table that contains all of the information dealing with any vehicle requests we receive, to include the start/end date & start/end time. I need to assign vehicles/trailers to each mission. The problem I'm having is that each vehicle request may require a different number of vehicles/trailers. So to get around that problem, I was thinking about doing a vehicle/trailer subform to allow the multiple combinations of vehicles/trailers.
Ok, up to now shouldn't be too hard to get it working. On the subform I want to select the vehicles or trailers from a drop down list, but I would like the drop down list to only display the vehicles/trailers that are not on a mission during the dates/times listed in the current vehicle request.
Is there a better design I can use to accomplish my task than what I am trying or am I going in the right direction with my design and just need further guidance with the programming? Any help I can get with this would be greatly appreciated!