Helen Borrie wrote:

> Lester's solution comes closest to what I'd recommend - and Lester should
> know. Lester's stuff keeps the British trains running.

Not sure about that one, but it would be nice to know that two trains
are not in the same place at the same time :)

I've been having a play with this since it popped up - because I need to
expand the room booking system on a project, and my simple method IS
probably going to fall over, but the 'free space' seems to be my best
option as an alternative. Since I log who has entered a booking, I'm
playing with the idea of making the user_id negative when they are
editing a booking, so that other users know that a change is in progress
and who is actioning it. Two people can't commit to the same record :)
This only really works because I'm not wrapping round midnight, so each
day has a single free space record - for each room and staff member -
but I only create that record IF the room or staff member is accessed.
Now what patents do I have to worry about ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services