Portal Filtering

[peterdrucker]

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

[efen]

Look at Ray Cologon's booking solution at

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

[peterdrucker]

That's exactly what I had in mind! Thanks a lot!!