Only need some direction--Can this be done in a Form?

[melrose]

Hi there. I simply need to know if this is possible in Access, and if so, what controls/methods to use. I'm trying to make a scheduling form containing a list of students and then multiple subject lists in which to associate those students with.

How could I stack multiple subject lists, such as 50 different lists, in which to drag-and-drop or enter students into? Users want the lists to be visible on 1 form (like the current spreadsheet), only having to scroll vertically to view all subjects and students. Subjects would change quarterly; the database would keep a record of classes, students, and grades.

TABLES:
Students
Staff
Subject Categories
Subjects
Grades
Attendance
Years
Quarters
jtblSchedules--joins everything

Attached is a screenshot of the desired form made with Access controls.

Any insight would be appreciated.
Mel

[OBP]

You can use Check Boxes to register the Subjects, but that means having inflexible Fields named for each subject.
The other alternative is to use a Multi Select List Box or boxes, but that is not how it should be done.
By good design you should have 1 student selected on a Mainform and then the Subjects chosen as individual records on a Subform using a Combo Box.
I know it is slower for data entry but it is much more versatile when you want to work with the data afterwards.

[melrose]

Thanks OBP; yes, I realize this is a non-normal set up. I was first thinking about having a different mainform-subform window for each class of the day (resulting in about 50 form-sforms on 1 screen). Now, I'm thinking about just linking Excel and Access together, using Excel for the scheduling part. Thanks again for your thoughts.

[OBP]

melrose, this database that I am working on for someone on the Tech Support Guy forum will give you an idea of what you can do with Check Boxes etc.