Help needed on Goofy SubReport Alternate

[Barry A&P]

My wife is working on a database that tracks a students Courses for
evaluations..
she had Fields for course 1 course 2 - course 8 ect.. because 4 courses
count toward their first eval and 6 courses count toward their second eval,,
this method although goofy works until you have to search 8 columns to find
wich student has taken a specific class.. i did a Union Query but im sure
there is a better way.

i set her up with a courses table, AutoID StudentID CourseID
dateCompleted, and tried to talk her into a subreport that lists the courses
completed for each student but she really wants the Course 1, course 2,
Course 3.. Controls on the report in the Eval1 section and course 5 - 8 in
the eval 2 section. course order doesnt matter but i am stumped on how to do
this.

can a control on a report be set to display the first record in the Courses
table where the reports detail section student id = Courses.studentID and the
same for control 2 record 2 ect...??? Maybe dllookup?? or maybe there is
a way to use two sub reports one limited to the first 4 Course records and
the second limited to the following 4 records?

Thanks in advance for your great idea
Barry

 

[Duane Hookom]

Your description of your tables and specs aren't real clear but it sounds
like you have properly normalized some data.

If I understand, I think you might be able to use a multi-column subreport
to display the related courses and evals.