I am using the quick search feature (in dropdownbox mode) in a sales planner and filtering it to show all names in the "Sales" field (user_name). What I want to accomplish (but can't seem to workout the code) is to have this filter look at the user_names db (instead of the sales field in the grid) and display only those names in the user_names db that have a user_type = "sales" .AND. user_status = "active".

This grid is used on the management side. The sales interface uses a simple filter in the a5w web page. This type of filter will be used in several grids.

Thanks