gatorjp

I am working on a database to help secondary school students choose majors in high school.Different High Schools have different major selections. I would like to create a drop down box field with the selections being the high schools in the district, and then, based on that selection, have another drop down box to allow the student to choose one of the majors offered by that high school. Can a selection by one drop down box control the selections offered in another drop down box?