Simple report with master/detail records

[dsajones]

Hi,



I've really struggled to find the information in Access help on how to create a very simple report as follows. It's a database of pupils with a record of each lesson they've had.

Master table - Pupils. Primary key is pupilID. Usual fields of name, address, phone etc.
Detail table - Lessons. Primary key of pupilID plus lesson date. Table contains lesson date, time, topic and outcome.

So I want a report where at the top of each page is the pupil details from the master table. Then a list of all lessons attended with the information from all fields in the Lessons table. It's exactly the same concept as an invoice with a header and individual details except I don't need any totaling of anything, just a simple record of the lessons attended.

I've tried using the report wizard and sort of assumed that the grouping option was what I wanted. But that didn't work at all.

Help!!

[Robeen]

Create a query that joins the two tables so that each Student's data [from both tables] is in one row of the Query.
Eg:
Select Master.Field1, Master.Field2 . . . Detail.FieldA, Detail.FieldB . . .
From Master, Detail
Where Master.PupilID = Detail.PupilID;

Once you do that - you can use the Query as the data source to build the report on.
Since all the data you need for each student will be in the query - you can use the Report Wizard and let it set up your Grouping etc.

Let me know if you have questions.

[dsajones]

Thanks Robeen. OK, that makes sense.

Cheers
David