List Function for related records
I have a print layout where I am trying to list a number of fields from related records, as of now I have had no success and an hoping someone here can help.
I have a table for people with a one to many relationship to table encounter which has a one to many relationship with table referral
I created a calculation field in Referral table, "c_completeRecord" which is a join of all of the fields in that table.
Then on the Encounter table I created a calculation field with List ( Referral::c_CompleteRecord ).
Unfortunately this lists all records from all encounter instead of just the encounter in the found set, I have verified that the layout is showing records from encounters and not people.
Is there anything I might be missing?