view based on two or more combined picklist fields
how can i create a view where values from two different picklists (which import data from the same field) in the same form are combined so that i am able to filter one picklist to see all records for a particular data.
Example i want to make a quotation form where i quote for two or more items and the items are imported from the items form. I am unable to view all records for a particular item as same item may occur in two different picklist fields