AnsweredAssumed Answered

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

Question asked by splaisan on Dec 12, 2010
Latest reply on Dec 13, 2010 by 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

Outcomes