2 Replies Latest reply on May 19, 2016 3:05 AM by bigtom

    Question abut Pop-Up Menu


      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.