I am having trouble with a multi-key relationship. I have 4 tables.
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?