im designing a database for a rental company, as part of a college project.
I'm still in the design process right now though and i have a total of 4 weeks to get a working prototype up and running.
In their database they want that if their product is being rented then they can just tick a box to say so (easy enough), but they want it that so when the box gets ticked a new field will become available to input what time it will become available again. They also want that product to become unavailable for that selected time to avoid overbooking.
i'm still relatively new to access so go easy on me!
Any help will be great
thanks.