Sending data from form to table

[songofsolon]

Greetings,

I am having a difficult time seeing this problem clearly, so I don't know if what I am asking is impossible or very simple, but I would appreciate any tips.

I am working on a scheduling form that involves 3 queries/tables: [EVL] queried student information, [Clavov] available classes for that student, and [ProsSched] the table that stores the individual student id "ProsID" with associated classes "ClassID"

What I would like is to create a form that would isolate the students, one at a time, display the available classes for that student, then allow the user to select multiple classes to assign for that student. Theoretically the form would then pass each appropriate "ProsID" and "ClassID" together as a record in the table [ProsSched].

This last bit is what gives me trouble. I can create a form-subform that isolates the student and available classes for him/her, but cannot for the life of me see how to make the class-student associations and save them to the table.

Thank you for any suggestions!

 

[Pat Hartman]

You have a many-to-many relationship. Take a look at the example database that I posted several months ago.

Many-to-Many Sample

 

[songofsolon]

Thanks very much Pat, the sample db was helpful. It's slow-going, but I think I'm beginning to get a better handle on what I need to do here.