AnsweredAssumed Answered

Question abut Pop-Up Menu

Question asked by Angelus81 on May 19, 2016
Latest reply on May 19, 2016 by bigtom

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)


Screenshot 2016-05-19 17.14.10.png


Now, how do I make the pop-up menu not displays the employees whom are been terminated because now the list are quite long.