I'm not sure I can explain this easily but here goes.

I have the following 3 file system for a sports club

Membership File (File A) - a list of members

Performances File ( File : - a list of performances

Competition Info File (File C) - list of venues and dates of competitions etc.

The files are related as follows:

File A related to File B via MemNo Field (membership number)

File B related to File C via CompCode field (Competition Code)

Here is what I am looking to do:

I want to have a portal in File A (Membership) showing performance information (from File : and also in the same portal where the event took place (from File C)

I realise that a portal can only link via one relationship so how can I get info from both File B and File C on the same line in a portal on a layout in file A?

I am stumped and lost somewhere so any help would be appreciated.

Thanks in advance

You can replicate the info of file C in file B:

Create a Venues field in file B, calculated as

RelationshipToCompetition::EventPlace

This field can be put in the portal you've in file A

If more than one record can be related to file B you can make a relational value list in file B, listing related event places, and a calc field

ValueListItems (FileB, TheRelationalValueList)

will return a return delimited list of the event places related to each performance

Thanks - works a treat. Simple when you know how - as always.

John

Many thanks from me, too. This had me stumped, but now the feature is working.