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?