Adding Students to classes

[Tommo]

Hi.



I am in the process of setting up a DB for my partners school.

I have student and class tables. I have these linked in a many to many with a junction table.

I am making a student data entry form and I cant work out how to add the student to the class.

Ideally I would have a combo box to select the class and then when one is selected a fresh empty combo box would appear beneath it.

[June7]

Options:

1. single form bound to the junction table with comboboxes for selecting class and student

2. main form bound to Classes and subform bound to junction table with combobox to select student

3. main form bound to Students and subform bound to junction table with combobox to select class

The 'fresh empty combo' would be a new record row in a Datasheet or Continuous form.

[orange]

Do you have a plan?
Do you have a description of the business surrounding the "school".
Student and Class are a start. But what about registration, courses, teachers, scheduling...
I recommend you do some serious analysis, with pencil and paper, to identify the business of the school you hope to automate in some fashion.

Here are some links to a few free, generic data models that show typical "things" and the "relationships" between them. Some of this might be relevant to your situation. A quick review will help you determine if your facts are typical or if you have special requirements.

School Registration
Student Roster
Student Information System includes several other data models (specifics)
Class scheduling facts
Class scheduling model

Don't overlook the usefulness of Google/Bing in your research and development.
Good luck.

[Tommo]

thanks for all this. Sorry no replies.

Have sorted now.

Thanks Orange. I don't think I explained very well.

I do have most of that stuff. I just didn't think it was relevant to the question.

[orange]

Glad it's resolved.
I saw you had only a few posts; quite a common combo question and no context/background for the question, so wanted to get a big picture view.
Glad it's all under control.