I have a database that contains two tables: Employees & Payroll, and they are related as
"Employee" ----< "Payroll"
In my "Employee" table, there is a field called employee status which indicates if an employee is active or terminated.
Currently, my "Payroll" table's employee name is using pop-up menu which is taken from "Employee" table's primary ID but employee's name is displayed from other field. (see below image for my setup)
Now, how do I make the pop-up menu not displays the employees whom are been terminated because now the list are quite long.