I am creating a form for a school and want to populate a hidden grade level field based on the teacher a student selects. So, if a student selects "teacher A" and "teacher A" teaches 3rd grade, then the grade level field would be dynamically populated with "3". My hope is to have students enter their teacher, but when the data is exported, we could also sort by grade level because it will be in separate field. I've searched the forum and can't find an answer. I have VERY LITTLE EXPERIENCE with the code that makes the form magic happen, so I'm hoping there is a low tech answer or a patient person who is willing to give specific steps on how to accomplish this. Thanks for helping out a newbie!