Hmmm. Actually I like the multi value approach from Nitewing that you describe. I can see how that executes much more quickly. Since time of day only applies to the first and last date of the range, you may be able to figure out some additional checking that looks at a time stamp or time field on just those two dates.
I've actually started rebuilding my entire solution from the ground up. And I'm trying to make it as simple as possible.
I used PhilModJunk's method of checking for conflicts within a date range using relationships. As explained here:
And I check for timestamps, not for dates.
What I do is:
I have a table of Bookable items.
A table of Bookings. Every booking books an Item Id.
I use the Philmods relationships to list all the Id's that form a conflict.
Then I make a relationship based on that list of "Conflicted Item Id's" and I make it "Not Equal" to the Id of my Table of Items.
That way I only see the items that are not conflicted.
Only problem there is that there always needs to be a value in that field, otherwise the relationship shows nothing.
So I did an "If IsEmpty" and gave that a value of 999999. That's an Id I will never have.
I don't know if this makes any sense to anyone, therefore I attached the example:
I don't know how fast this will perform on Filemaker server because now I only tried it as a local file.
Im starting to implement it in my actual filemaker file that's on a network today.
Found a little error where the List's where not working correctly.
Fixed it now.
i'm trying to set up a booking reservation for cars (a simple one), i saw your post very interresting. I wonder if you can post an example of you booking in order to see how it works and understand
Thanks a lot
I actually started from an example from this website:
There is a demo file you can download.
And I adapted it a little to my needs.
I hope this helps.