Custom Value List Filters
I have a table that imports user names and departments from Active Directory. I want to use this list in several drop down fields, but need only certain records displayed in certain drop down boxes. For example, one field allows you to select which manager is required for approval. In this drop down list, I only want to show managers. Another drop down list allows a user to assign a task to IT personnel. It this case I only want IT staff to be displayed.
I prefer not to create multiple tables if possible.
Is there any way to do this?