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
9/10/08.
Room B has been rented from 7/28/08 to 8/4/08 and again from 9/15/08 to
9/20/08.
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
to
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.
Regards,
Karin
