Database Sub Form Problem

[AccessNewb11]

Hello all,
Thank you in advance for any help you can offer! I am an Access Newb and am still trying to figure out parts of using the program. I have attached my database for your review in helping me solve my problem.

I am building a database where I can register officers from law enforcement agencies into classes. I want to be able to create queries as a roster for each class, with the date. For instance, one query would be called "Arresting 101 8/30/14".

Anyway, here is my problem: I inserted a sub form onto the main form, called "Name of Class". I then converted the "Name of Class" field into a combo box so that I can choose the class name easier. However, when I choose a class to go with the student, for instance John Doe is registering for Perishable Skills, it won't save with John's record. If you load the Student table, you will see I have other stuff saved for John, but I cannot get the Name of the Class to save in his record...therefore, it would not show up on the query, which isn't working either, but that's another forum post!

Help!



Thanks again.

~Laurel May~

[June7]

Table structure probably not correct. Can student attend multiple classes? Each class can be associated with multiple students? Consider:

tblClasses
ClassID
ClassName
ClassDate

tblStudents
StudentID
StudentLast
StudentFirst
StudPostID
StudAgencyID

tblStudentClasses
ID
ClassID
StudentID
DateEntered
ProcessorID
DateReimbursed

Then options for data entry:

1. single form bound to tblStudentClasses with comboboxes to select student and class

2. main form bound to tblStudents and subform bound to tblStudentClasses with combobox to select class

3. main form bound to tblClasses and subform bound to tblStudentClasses with combobox to select student