1 Reply Latest reply on Sep 22, 2016 2:33 AM by Mike_Mitchell

    Report one to many relationship

    pimech

      Hi,

      I have two tables, People (Name) and Books-People (ID, Name, Category, Title).

      Name and Name are joined by a one to many relationship.

       

      I.E.

       

      People

      Name

      John

      Marco

      Bill

       

      Books-Persons

      ID Name     Category     Title

      1 John       Math            Geometry for dummies

      2 John       Math            Engineering math

      3 John       Grammar     The Grammar book

      4 John       Grammar     Grammar and vocabulary

      5 Marco     Math            Geometry for dummies

      6 Bill          Grammar     Grammar and vocabulary

      7 Marco     Math            Engineering math

       

      I want a report that list people and book category related, i.e.

       

      John

      Math

      Grammar

       

      Marco

      Math

       

      Bill

      Grammar

      Math

       

      How can obtain this?

      Thanks

        • 1. Re: Report one to many relationship
          Mike_Mitchell

          Build a List view report from the context of Books-Persons.

           

          Place a sub summary part on the layout, sorted by Books-Persons::Name.

           

          Place another sub summary below it, sorted by Books-Persons::Category.

           

          Delete the Body part.

           

          Place the Name field in the Name sub summary, and the Category field in the Category sub summary.

           

          Sort the records by Books-Persons::Name, and then by Books-Persons::Category.

           

          HTH

           

          Mike