Preventing date/time duplicates in a portal

[bradford]

Imagine a portal of appointments. Imagine not wanting to book an appointment on the same day, at then same time, as another entry. Imagine a waterfall, with laptops floating downstream.

Basically I'd love there to be a "Unique" checkbox for a calculation. Instead I need help creating a relationship. That's my guess. I have searched the forum with no luck.

[BobWeaver]

Mmmmmm.....laptops floating downstream....

There have been a few discussions about this in various threads in this forum. Try doing a search on "reservation system" or similar. Cobalt Sky gave a good solution for this.

[BobWeaver]

This is the thread. It's quite long but there's probably an answer for you in there somewhere:

http://www.fmforums.com/threads/showflat.php?Cat=&Number=61669&page=&view=&sb=5&o=&fpart=all&vc=1