2 Replies Latest reply on Dec 13, 2010 1:22 AM by splaisan

    getting all field2 content from by-field1-related records as a merged string

    splaisan

      Title

      getting all field2 content from by-field1-related records as a merged string

      Post

      Table 1 has ID as unique ID and extra fields of no relevance here except the last one

      Table2 has of course ID as well for one to many relation and also has a field called (type).

      There is a variable number of related fields in Table 2 for each field in Table1.

      from Table 1, I would like to see all existing 'types' from Table2 for each record as a merged string in a calculation field (annoscore).

      I tried to add a second relation (type x type - not shown here) or (ID x ID as in screenshot below) linked to table2 and get the merged type string from there by calculation but it loops forever annoscore = calc[ Substitute ( all_types::var_type ; "¶" ; "-" ) ]

      I was expecting to get a paragraph-separated list of all matching types by the x-relation but it does not do it.

      Please help!

      Stephane

      Screen_shot_2010-12-12_at_17.19.10.png