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

    Question abut Pop-Up Menu

    Angelus81

      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.