Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format



#1: Scheduling question

Posted on 2008-04-23 21:02:00 by Karin Zirk

Filemaker Pro 9

Three hotel rooms: A, B and C

Room A has been rented from 8/1/08 to 8/5/08 and again from 9/1/08 to

Room B has been rented from 7/28/08 to 8/4/08 and again from 9/15/08 to

Room C has no rentals on it.

Now I have a new reservation for a room from 8/3/08 to 8/10/08 that I want
assign to one of my three rooms.

So I have two questions.

1) In a drop-down value list, is there anyway to indicate that either only
Room C is available
or to show by a flag like "#" in the list that Rooms A and B have a conflict
for the new reservation.
(So it would look like this:
# Room A
# Room B
Room C

2) In trying to automatically populate my reservation, is there anyway to
perform a find
that would only find record C in this instance without a user having to type
any information
into the find request.

I've been tearing my hair out on this way and just can't seem to get a
handle on how to
approach it.

I've looked at what the template for Resource Scheduling but that's not
going to work in this situation, because
ultimately, I need to schedule 100 rooms at a time.

Thanks in advance for any help that may come my way.


Report this message