Trying to build a one to many report
Lets say I have two tables that look like this:
Each T1_ID can appear multiple times in T2
I want to generate a report that looks like
Text0 Text1 Text2, Text2, Text2
Is this possible? Ideally, I would like to create a calculated value in T1 that contains all of the related Text2 values for all of the matching fields in T2. Is this possible?