Equipment Rental: Check to See if Equipment is Booked
Hey, really need some help with an issue.
I am making a equipment rental database for a local film co-op. I have a rental form set up, and everything is working except one thing. If someone goes to reserve an item on dates that overlap with another item, I would like message to come up saying the item is not available on those dates. I tried following the solutions in the forum below, but couldn't get them to work.
The forum is a few years old, so I thought I'd start a new topic.
A few details. You can book equipment out in advance.
I have a table for the equipment, for the rental form, and then for the list items.
Any posible solutions?