Jump to content
Sign in to follow this  
SharkFin85

Relationship between Repeated fields

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

generic_reservations_dezign.gif

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

event_reservations_dezign.gif

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.