Passing data to a form AND performing append query to table

[ivalum21]

I have the following tables: Students, Enrollments, Classes, Sessions,
Attendance.

I have a form based on Classes and a subform based on Sessions. I want the
user to be able to select the appropriate session then a new form appears
with a list of students that are signed up for that session.

My Attendance table has the primary key of SessionID, StudentID, and Date.
There is also a Yes/No checkbox to distinguish if they were present on a
given date.

Basically, what I am trying to do is create an electronic attendance sheet.

Any help would be great, thank you,
ivalum21

 

[G. Vaught]

The Microsoft Office Template Site already has a database for tracking
classes and students. It does not have an attendance sheet, but it is very
easy to create one by combining the table of students with the classes table
via a query.

 

[ivalum21]

Yes, but I have many classes offered at many different times, so I created a
Sessions table. I also have many students enrolled in many different
classes, therefore I created an Enrollments table.

So in that case would I just combine the Sessions and Enrollments tables
together to get my attendance sheet?

- ivalum21