AnsweredAssumed Answered

Trying to build a one to many report

Question asked by MrMLK on Apr 2, 2014
Latest reply on Apr 2, 2014 by philmodjunk

Title

Trying to build a one to many report

Post

     Lets say I have two tables that look like this:

     T1

     ---------

     T1_ID

     Text0

          Text1

           

     T2

     --------

     T2_ID

     T1_ID

     Text2

      

     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?

      

     Thanks.

Outcomes