Rental Scheduling

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

0 5 685
5 REPLIES 5
Top Labels in this Space