AnsweredAssumed Answered

how to concatenate values from multiple related record into a single calculation field

Question asked by WilliamChang on Aug 17, 2011
Latest reply on Aug 6, 2015 by TSGal

Title

how to concatenate values from multiple related record into a single calculation field

Post

hi, I apologize if this has been asked and answered before, I haven't been able to find a solution.

I need to concatenated multiple related records into a single text calculation field on the parent table/layout seperated with some delimiter

I have a FAMILY table with a primary key FamilyID that joins to the CHILDREN via FamilyID

Given a record in the FAMILY table and 3 related records in the CHILDREN table,the calculation field should have the value:

Thomas;Matthew;Kathryn

Is there a function that I can call to lookup all related records?

thanks in advance for your assistance.

Sincerely, William

Outcomes