1 Reply Latest reply on Apr 2, 2014 9:32 AM by philmodjunk

    Trying to build a one to many report

    MrMLK

      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.