Eliminating elements from a pick list based on elements in another pick list
I have 2 pick lists: picklist 1 and picklist 2.
Each pick list is populated by elements based on a separate search criteria on 2 different views.
picklist 1 is typically a subset of picklist2.
I would like picklist 2 to persist as a pick list populated with only those elements that are contained in both picklist 1 and picklist 2.
Can this be done?
Robin