For example, I have a drop down that shows all employees. I just want to show in the drop down employees who are technicians (which can be found in column named "technician" and the value would be 'Yes')? Appreciate the help.
you have to use a relationship
Retrieving data ...