To be sure I'm understanding the request correctly, you have a form with a drop-down of users and you want to only show those users that are listed as a Manager, right?
If that is the case, then you will need to:
- Be sure that your drop-down isn't just a User field, but is a reference field to the table where your Employees are listed. (From your description, it sounds like this could be the same table where your drop-down is, which is fine.)
- Once you have that setup correctly, you will then want to create a report on your Employees table and filter that report based on the Title field.
- Then, go back to your form, edit the Element Properties of your drop-down and on the right side, select the report you just created. This tells the form to only show those employees that meet the criteria setup in the report. If anyone's title changes, the report will automatically update and so will the available names in the drop-down.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------