how to concatenate values from multiple related record into a single calculation field
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:
Is there a function that I can call to lookup all related records?
thanks in advance for your assistance.