Question about dropdown menu visibility
I have two tables. One employee table which contain detailed information for my employees. The other table is the payroll info with several fields that help me to calculate their payroll amount.
On the employees table, I have a radio button field with values: active and inactive. Then, on my payroll table, I have a Pop-up menu field that is looked up the employe_name fields from employee table. Currently this Pop-up filed shows all the employees from the employee table disregard active or inactive.
Is there a way that I can make the Pop-up menu only show active employees?