4 Replies Latest reply on Mar 27, 2017 7:42 AM by manuelruizga

    Concatenate same field in different records from parent table and restricted to a found set in child table layout

    manuelruizga

      For the purpose of printing a document, I need to concatenate the value of the same field in different records from a found set. There would be 2 tables envolved, "clients" which is parent to "procedure".

       

      I need a field with all the diferent client's names listed but only showing those related to the found set in the "procedure" layout.

       

      I could do this with a summary field and a "list of" function if the client's names were in the "procedure" table but the problem is, they are in the related table and I can't figure out how to aproach this.

       

      Can anyone help me with this?

       

      Thanks for any suggestions!