I would like to create drop down menu using a value list that is prone to change. For example, I would like to assign a teacher to a student in the student's record. The student record would include an assigned teacher field that has drop down listing of teacher names that one can choose from. However, the teacher value list should only include active teachers. It should not include teachers that are currently inactive (such as teachers who are on sabbatical). I understand there needs to be relationship between the student table and teacher table, but I'm not sure how to create the value list for the drop down menu. Thanks in advance.