Scheduling question

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