Multi-student Forms & Reports

[MarkMcAllister]

Greetings once again,
I created a database to record lesson information (see attached sample). When there was only one student per record, everything worked fantastic.


However, management would like to have one record per lesson, which means that up to eight students would need to be accounted for.


Adding additional Student_IDs to the lesson record table and the associated links to the student table was simple.
Inputting lesson information was pretty straightforward.


The problem arises with output.
There is one report to review an individual student's past lessons.
Also, there is a form in which to export the lesson's public comment.
Both use different queries, but with the same name as the form and report.
Both the report and exported Excel file are blank, no data.


Any assistance, as always, is much appreciated.
M. McAllister




P.S. I'm building this in A2010, but saved as A2003 (working environment).

[ItsMe]

I did not look at the database but ... maybe a third table would allow you to lookup a many to many relationship. A third table could store the PK values from the other two tables. Then, you could query the third table.

[MarkMcAllister]

ItsMe,
Yes. Others on other forums suggested the same approach.
I forgot about this method...
It is the road to take.
Thanks for the input,
MNM