Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Getting info into a portal


This topic is 7859 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

  • 2 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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