Filter Using User Roles

[Lee Vance]

I am pulling a list of users from a database that share a common e-mail
address with Active Directory. I've created group-based roles for my form
from the Active Directory accounts.

I have several drop downs that give a list of users in my database. These
users are also in Active Directory and placed in the appropriate groups that
I used in my user roles.

Is there a way I can filter my employee drop downs based on my user roles?

For example, I have a drop down for project managers. In the database
containing the employees, there is no column that differentiates project
managers from anyone else. However, in Active Directory, there is a Project
Manager group, which I have used to create a user role for Project Managers.

Since the database and Active Directory share the same e-mail addresses, is
there a way of doing this?

Thanks,

Lee