I would recommend you think a bit more about this. You are likely to run in to limits in how many list entries can sensibly go into a CC dropdown. If a primary school has 7 years/grade with 2-4 classes per year and 25ish kids per class then the list length of student names could easily be 700.

The flow would be better done by firstly selecting the class which would then allow a macro to lookup the teacher(s) name and populate the 25odd kids names into the first dropdown.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia