AnsweredAssumed Answered

Equipment Rental: Check to See if Equipment is Booked

Question asked by MatthieuBelanger on Aug 19, 2013
Latest reply on Sep 25, 2013 by philmodjunk

Title

Equipment Rental: Check to See if Equipment is Booked

Post

     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.

     http://forums.filemaker.com/posts/ade213beb3

     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? 

      

Outcomes