Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot



#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