Discussions

Expand all | Collapse all

Parent Record with Summary fields of multiple Children

  • 1.  Parent Record with Summary fields of multiple Children

    Posted 03-22-2019 14:14
    I have 2 tables Parent and Child with a 1 to many relationship where Parent can have many children.

    I am trying to create summary fields in the Parent record such as

    First Child
    Second Child
    Third Child
    Fourth Child
    etc..

    struggling to make this happen.. 

    Any help would be greatly appreciated.


  • 2.  RE: Parent Record with Summary fields of multiple Children

    Posted 03-23-2019 00:33
    I suggest that you first summarize all the children up to the Parent using a Combined Text Summary field.

    Then, you are asking how do parse out the individual children teams.

    Make a formula text field like this

    var text value = ToText([My Combined Text summary field]);

    Trim(Part($value,1,";"))

    That will be the formula for the first child

    Then copy that field and replace 1 with 2 for the 2nd child.