May 10, 2019 04:10 PM
I have trouble wrapping my head around a database I’m building for a client.
The concerned DB is for equipment rentals and my problem is making clear what’s available at a given date for rental. In the Rental table, I have a field for the outing date and another for the return. When a new rental is made, we would need to enter specific in/out dates and see the equipment available for those dates.
Any idea on this?
May 10, 2019 05:03 PM
This is not an easy thing to accomplish! I was able to build a booking system for a client, though, that allows one to check the availability of campgrounds even against future bookings.
I had to capture ALL of the dates in between the start and end date of every booking created for each campground with a ridiculously long and redundant formula. And then to actually check for available campgrounds, the attendant has to input the desired start and end dates into a table designed to query the bookings records for any that met the criteria.
I will PM you a an invite to view a copy of the base I made for this so you can poke around and see if you can make use of the system.
May 17, 2019 07:40 AM
I’m quite surprised that there isn’t an easy enough solution for this, thru a form per example.
I guess I would put it like this : there a way to do a conditional drop-down menu in a form?
Nov 01, 2022 08:29 AM