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

[williamhchang]

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

[Fitch]

The List function will give you a return-separated list of the related children.

Wrap that in a Substitute function to replace the returns with semicolons.