I'm currently working on a job costing solution. The solution consists of a contacts table. These contacts can be clients, employees, sub renters or subcontractors. They are distinguished with a check box. For example, employees who qualify for labor pay have this box checked. Sub renters and subcontractors have their respective box checked as well.
I would like to achieve this:
After adding a new job I'd like to add labor by choosing an employee from a drop down list. When I click on the drop down list I would like ONLY active employees who qualify for labor pay to appear on this drop down list. Currently, all contacts (including clients, sub renters and subcontractors) are appearing. I'd like to narrow that list down to only employees.
I'm new to FileMaker and have very little knowledge of how it works.
Thank you to anyone who can help: