getting all field2 content from by-field1-related records as a merged string
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.