On Fri, 23 Apr 2010 07:48:01 -0700, Gntlhnds
wrote:

Thanks for the response. The best way to describe my situation would be like
an elementary school, where each class takes the same courses at the same
time. And, no, my tblCourseGrades is not populated with the courses and
students. I'm assuming I would use a query to do this, but how would I work
that? I have classes starting about every two weeks or so, and each class
takes the same courses, so I would need to frequently update that table. I
hope this is enough information. Thanks.

A Query probably will be involved, but you would (I would guess!) need to pick
somebody's brain for the information that Alisia Gonzalez is assigned to the
Management Development class starting May 3. Normally one would do this using
a form and subform arrangement; this could be done in two ways - you could
have a form based on the table of students with a subform based on what I'd
call the "class enrollment" table, allowing you to pick whichever classes this
student needs. Alternatively (or in addition) you could have a form based on
the class table, with a subform allowing you to pick students from a combo box
to enter them into the enrollment table.
--

John W. Vinson [MVP]