How to get two query results from one record

[Bob Richardson]

In a typical school DB situation, some classes have two teachers. At the
moment I print a class roll (list of students) for each class and that is
given to THE teacher. When there are two teachers for the class, this
doesn't work. We end up photocopying the class roll and hand that copy to
the 2nd teacher. That's because one class=one class roll report.

If I set up my class record to allow for two teachers, how will I print out
two class rolls for this class? It seems I need to be able to query the
class table to end up with more records in Q_Class than I started with in
the Class table. Is there another work-around or different approach I should
consider?

 

[Duane Hookom]

If you have two (or more) teachers for a class, this should be stored as two
(or more) records in a table. Is that how your table is set up? Maybe you
should share something about your "typical school DB".

To be honest, some of the worst table structures I have seen in these news
groups have been created for schools.

 

[Bob Richardson]

As usual, I'm trying to fit the square peg of reality into the round hole of
Access. It's necessary to view things from right perspective, and that may
be more difficult to do for the typical educator

It seems I need a one to many relationship between Class and Instructor.
Viewed from that perspective, the solution seems straight forward.