Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

phpmyadmin fehler rechte unerlaubte mischung, WWWXXXApc, lilo trying to map files from unnamed device 0x0000", Wwwxxxapc, CAM::PDF::Renderer::TextF Fragen, adodb.recordset error '800a0cc1', php save mails as eml, WWWXXXAPC, sqlexpress database file auto-creation error, sqlexpress database file auto-creation error



#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