Filter popup menu value list based on other table

[somasf415]

I have a employee table that has a list of all employees which then have two different fields with radial options 1. active or non-active 2. sales rep or installer

In another table i have a popup menu based on the employee records but the list is very large and i would like to filter it based on the field being entered.

For example in the sales table i would like to assign employees to the sale, one being a salesrep and also an installer to each sale. In the salesrep field I would like a popup menu that filters from the employee table based upon the criteria (active, and sales rep), in the installer field i would like (active, installer)

any help?

I added a screen shot of this section of the database, i am doing this in brazil so Funcionarios = employees and clientes = sales (portuguese)

[somasf415]

I think i have figured out at least that i need to make a table occurance of the employees table and somehow have it only show the employess that have the field values i want in the two fields i want to sort by. For example I need to create a table occurance for employees names "active salesreps" where the table is filtered by the two fields status = active and type = salesrep .

I just don't know how to accomplish this.