Drop-Down List based on Calculation but having an over 50 moment!
Yes, I am a newbie, and I am over 50 so please bear with me.
I have an Employees table which has a Status field. An Employee can have the status of: Student, Teacher, etc.
I have a Classroom table which lists the Class Name, room number, etc.
On my Classroom Layout I would like to have a Teacher Drop-Down List which only shows the Employees who have the Status "Teacher", so you can pick which "Teacher" will teach that class and not have a "Student" teaching the class.
As I said in my title, I'm having an over 50 moment, I've done this before, but for the life of me, I can't figure out how to make this work on this layout.
Any help would be greatly appreciated.