I have an assignment on access.
I have to build a database about a car shop which allows customer to rent a car for X amount of days.
I’ve built all the tables and made the relationships.
The bit I could do with some advice for is I’m trying to make a query that will show all the available cars which I can do but the bit I’m not sure on is how to stop someone say using car 1 for the 2/2/07 and then another user books car 1 for the same date. - Would an If statement work? Like iff(date=2/2/07)??
Also, all the cars are in classes – A to E would there be a way to offer a user another class to use such as if all class A was used up for that date to allow them to look at Class B rather – would a combo box link work???
On and fianly is there any way to get the search results to appear on a form? I've seen on example but I had no idea how they did it. - I think its something to do with sub forms??
Cheers for any help. I'm not looking for you guys do to do everything. Its just really getting me started on how solve that problem! [font]
This post has been edited by Jman08: 27 March 2008 - 02:59 AM