AnsweredAssumed Answered

How to make a report with three related tables

Question asked by cob on Feb 5, 2019
Latest reply on Feb 5, 2019 by beverly

I do have a Parent, Child and Grandchild tables with a relation one to many and I want to make a report as follows:

Parent

     Child

          Grandchild

 

If I base the report on the Child table the Parent and Child appear correctly as liked, but on the sub summary of the grandchild appear always the same value.

 

If I base the report on the Grandchild table only the first Parent and Child combination appear but the others don´t and the the Grandchildren doesn't appear at all.

 

If I base the report on the Parent table all the parents data appear combined only with the first child of each. Grandchildren data doesn't appear.

 

Can someone indicate what did I made wrong?

 

Thanks

Outcomes