June 4, 201015 yr Newbies Hi there, Here goes my issue: I have two tables - Events and Facilities. The user sets a date and a start time/end time on the events table. From all available choices, he picks a facility. My purpose is to restrict the number of choices accordingly to the room availability. Let's say we have an event set for today at 18h00 to 19h00 on room A. If we schedule a new event for the same period only room B will be available for selection. I'm attaching a sample fp7 so that this looks more clear. Can you give me a hand? Thanks! database.zip
June 5, 201015 yr Look at Ray Cologon's booking solution at http://www.nightwing.com.au/FileMaker/demos7/demo705.html
Create an account or sign in to comment