Selecting multiple items under one field? (e.g. enrolling one student in ... )

[Oimoi]

(e.g. enrolling one student in multiple classes.)

Hello! I'm having a spot of trouble and would appreciate any help at all. (I'm still an Access novice, so apologies in advance if something doesn't make sense.)

My three tables are Student, Class, and Registration.

I created a separate form called "Registration" where you can enroll a student in a class that you select from a drop-down list. All primary keys and relationships are in place, and it works fine. However, my question is: how do I enroll one student in two or more classes on the same form?

Thanks in advance!

 

[pbaldy]

Presumably Registration is a many-to-many junction table? Options would include a form/subform where the subform was in continuous or datasheet view, or:

http://www.baldyweb.com/MultiselectAppend.htm

 

[Oimoi]

Hello again, Paul.

And I'm actually not sure what you mean by a many-to-many junction table.

My registration table currently includes Student ID, Class Code and additional payment information (e.g. payment amount, type). I fiddled with relationships to where the ID and Code are linked to the Student and Class tables respectively. Not sure where to go from there.

 

[arichins]

Hello again, Paul.

And I'm actually not sure what you mean by a many-to-many junction table.

My registration table currently includes Student ID, Class Code and additional payment information (e.g. payment amount, type). I fiddled with relationships to where the ID and Code are linked to the Student and Class tables respectively. Not sure where to go from there.

You'll want to have your student information in one table, your class information in a 2nd table, and a 3rd table that records a student's enrollment in that class. That table would have the key to the Student table and the key to the class_table.

To enroll a student in multiple classes. You could have one control that selects the student, another that selects the class, an "enroll button", then write the keys for both to the enrollment table.

 

[Oimoi]

Thanks so much for clarifying. Makes perfect sense now. (Though, the key word "junction" should have given that away. Having an off day here.) Gonna play around with both of your suggestions now, and I'll let you know if I run into anymore problems. Thanks!