I created an app a couple of years ago for us to use in scheduling rentals for our inflatable company. The one problem I have is when we put in a rental date, it doesn’t limit our choices to only the units that are available. Does anyone have any suggestion on how I can do this? I’m rebuilding the app from the ground up to make it better so now is the time.
Currently I have a table for:
Customers
Inflatable Units
Rentals
The Rentals table contains a “start date” field and an “End Date” Field and a related column for Customer and Inflatable.
I would appreciate any recommendations.
Thanks,
Rob
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |