AnsweredAssumed Answered

Drop-Down List based on Calculation but having an over 50 moment!

Question asked by ChatAtkins on Feb 9, 2012
Latest reply on Feb 13, 2012 by philmodjunk

Title

Drop-Down List based on Calculation but having an over 50 moment!

Post

Hi There,

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.

Outcomes