I'm looking for some help creating a summary view. I know how to do it, I just can't get my head around the table and how to display the data that I require.

My ultimate aim is to have a list of employees and when I click on one, it shows a summary of all training sessions that that person has attended. 

I have two tables:

Employee

& 

Training Course

When a training course is 'booked' it chooses an employee from a lookup in the form. The tables are therefore linked. 

When i create a report based on the Training Course table, it allows a link to the people table so I can pull data from both tables into my report. Despite grouping by person, the summary will only show the record for the single course booking.

E.g.

David      Course 1      1/1/1990

David      Course 2      2/3/2000

David      Course 3      30/1/2015

If I try to create a report based on the People table (which I think would be the most logical), there are no options to pull any of the Training Course records in. The link only seems to be one way. 

I want to be able to see a list of people (which makes me think that the report needs to be based on the People table)

David

Keith

Simon

... and when I click on David, it should show:

David

      Course 1      1/1/1990

      Course 2      2/3/2000

      Course 3      30/1/2015

Can anyone help me achieve this please?

Thanks

David.