Adding an extra relationship

[frommy]

I have a database of Theatres, and by relating a table by City and Theatre name I am able to call up data in a portal for each time a tour visits that venue. Sometimes, however, the data in some parts of the venue needs to be called from a different record (Cities have festivals which are administered by a whole different set of people). I would like to still keep the data from the City & Theatre, but somehow manipulate certain records to show from the parent of the festival instead of the Theatre. I can add a trigger for this in the form of a tick box, or a script button, but I am now stuck as to how to call the information from the two separate records.

Any advice gratefully received.

All the best

James in UK.

[comment]

I am not at all sure I follow this correctly, but it seems that you could use a tab object to switch between two portals.

[bcooney]

And I'm not sure I follow the data model either.

To me, you'd need:

Tours->Bookings->Venues

Each Booking would have a _kF_VenueID and DateStart, DateEnd and any other data specific to that Booking, such as ManagementBy_ID. The Booking would also have a flag that denotes whether this is a festival or not, and perhaps the _kF_Festival_ID.

The relationship up to the parent Venue record would tell you the City.

You would not relate by City and Theatre Name to anything. Relating by text values will lead to errors.

So, what tables do you have? Seems to me you're confusing attributes and tables.

[frommy]

Thanks for taking the time to reply.

It's probably best if I post a copy of what I have created, and you can see how it works, and what I need to do. As you can see, the booker types in the name of the city, and then a drop-down list for the venues in that city appears in the venue column. The example I have set is for Brighton where there is a festival which uses all of the Brighton venues, but the details of the contact, email and phone need to be different than those of the venues.

I think my issue here is how I would have a different field show up in the portal row.

Does this make my problem a little more clear?

Thanks a million

James

JFLL_Copy.fp7.zip

[frommy]

After all that, I have worked it out myself! Turns out all I needed to do was add in a calculation field that reacts to a Flag field. When that is clicked, the calculation field will show info from the Festival field. Easy as pie! Sorry to waste your time, but thinking differently about it has really helped the matter.

Thanks

James