Correction Relation****p2_3:
Try:
Start <= Arrival
Start >= Departure
End <= Arrival
End >=Departure
ALawrance
------------------------------
"Al Lawrance" <ajlawrance@[EMAIL PROTECTED]
> wrote in message
news:mE7Rj.226687$pM4.51989@[EMAIL PROTECTED]
> Set up a relational links based on date ranges....
>
> Table 1: only 1 record.
>
> Arrival Date:
> Departure Date:
> Constant = 1 (calculated field)
>
> Table 2: record listing all rooms in motel (e.g., A, B, C, D... etc.)
>
> Room #
> gStart Date (global)
> gEnd Date (global
> Constant = 1 (calculated)
> Room Status calculated field
>
> Room Status calculation: If (Count(Relation****p 2_3) >0; "Booked";
> "Available")
>
> Table 3: records where you store the rooms that are reserved.
>
> Room #
> Start Date
> End Date
> Occupant Name
> Address
> etc.
>
> Realtion****p 2_3
>
> Table 2 ................................. Table 3
>
> Room # = Room #
> gArrival Date >= Start Date
> gDeparture Date < = Departure Date
>
> Set up a second relation****p between Table 1 and 2
>
> Call it.. Relation****p 1_2 based on
>
> Table 1 Table 2
> Constant = Constant
>
> Set Up a ****tal in Layout 1 with TOC 1 to list the motel room records
> meeting the above relation****p (constant = constant) which lists all
rooms
> in motel as follows:
>
> Run Script that sets global dates in ****tal equal to dates entered in
TOC
> 1 to see what's available
>
> Room gStart Date gEnd Date Room Status
>
> A 04/01/2008 04/05/2008 Booked
> B 04/01/2008 04/05/2008 Booked
> C 04/01/2008 04/05/2008 Available
>
> Group the fields in the ****tal row and link it to a script that will
popup
> a window to enter the info for booking the room.
>
> Hope this helps.. with part 1 of your question.
>
> Al Lawrance.
>
> "Karin Zirk" <kzirk@[EMAIL PROTECTED]
> wrote in message
> news:8oudnaE_PP84GpLVnZ2dnUVZ_uOdnZ2d@[EMAIL PROTECTED]
>> 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
>>
>>
>>
>
|
