AnsweredAssumed Answered

Multi-Key Relationship

Question asked by tm9 on Feb 19, 2014
Latest reply on Apr 9, 2014 by Mike_Mitchell

I am having trouble with a multi-key relationship. I have 4 tables.

 

1. Person

2. PersonOrganization

3. Organization

4. Requirements

 

The Person & Organization tables are a many-to-many relationship.

 

I would like to have a field for each person record that also stores the KP's of the organizations they are apart of to be used as a Multi-Key to related each person to the respective organizations requirements.

 

I have a calculation field in the Person table " List ( person_personorganization_ORGANIZATION::__kp_Organization ) " It works to return a list in the field (I think with carriage returns) of all the organization KPs the person is a part of.

 

However..... The person records do not show up in a portal when viewing a layout with a Requirements table. BUT.. When I change the field from a calculation to a normal field and manual enter in multiple KP's pressing enter each time the relationship works and the portal shows the persons...

 

Why is this??? Why doesn't the list calculation work?

Outcomes