How can i make a relation between repeating fields. The relation is working only for the first repetition of the repeating field. ((i can't use the "Extend()" function in the table relationship)).

Edited April 26, 200718 yr by Guest

Why would you want to do this? Can you give a better description of what and why?

hi, Thanks.

Its for a guest house (booking).

So i have a Main Table (Booking Main) and in this table a repeating date field(31times)("DateRep") and a repeating room field(31times)(for each room), the room is looking the ArrivalDate and DepartureDate of each reservation from a other Table (Booking Details) so in each repeated room field will appear only the correct reservation (in the correct date). I need to make a relation between the repeating date field and the Arrival and departure date fields of the "bookingDetails" table (BookingMain::DateRep≥BookingDetails::ArrivalDate AND BookingMain::DateRep≤BookingDetails::DepartureDate) .

The Problem is that the relation is working only for the first repetition of the repeating field. i try with the "Extend()" function too but its not working.

THANKS :)

Edited April 27, 200718 yr by Guest

Unless you need to count overbooking or such have repeaters no proper use here. So before you dig you self too deep, do you need to investigate this:

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

--sd

thanks

You may want to look at these database models for a normalized relational design:

OR this one which also has an entity to map the reservations with an event, wedding, convention, etc....