6 Replies Latest reply on Aug 6, 2015 9:36 AM by TSGal

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

    WilliamChang

      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