johnrh Posted April 27, 2003 Posted April 27, 2003 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
Pupiweb Posted April 27, 2003 Posted April 27, 2003 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
johnrh Posted April 27, 2003 Author Posted April 27, 2003 Thanks - works a treat. Simple when you know how - as always. John
Newbies CSM-101 Posted May 5, 2003 Newbies Posted May 5, 2003 Many thanks from me, too. This had me stumped, but now the feature is working.
Recommended Posts
This topic is 7859 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now