AnsweredAssumed Answered

Report one to many relationship

Question asked by pimech on Sep 22, 2016
Latest reply on Sep 22, 2016 by Mike_Mitchell

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

Outcomes