Two related combo boxes in a form?

[Aleksandra]

Guys, i need your help.

I've got 20 schools in my database. In each school there are 5 classes. I'm making a form that'll be a kind of a search engine, and will display data about the chosen one.



So I made a combo box with school names in it. I need another combo box which will contain only classes that are part of the school chosen in the first combo box.

For example, if i have School1 ( with classes: Class Art, Class Physics, Class Math, Class Music, Class Sports ),
School2 ( with classes: Class 1, Class 2, Class 3, Class 4, Class 5 ),
School3 ( with classes: Class Accounting, Class Economics, Class Math, Class Business , Class Finance )
etc.

and in the first combo I chose School1, I want that other combo contains only 5 classes regarding School1, not all of them.

Thank you

[Aleksandra]

I've done it

[RuralGuy]

I've done it

Do you want to share your solution with others that read this forum?