Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 1
Registered: ‎10-06-2010

Finding Contacts based on a common pick list value

 We are trying to identify all contact records whose account record has a certain pick list value assigned.  Specifically, we created a custom pick list that identifies the ERP system used by the account.  I now need to identify all contacts whose account record has "Sage MAS500" (one of the pick list entries) for example.  I've tried query builder and look ups but nothing works so far. Any help is appreciated. 

Employee
Posts: 314
Registered: ‎05-19-2009

Re: Finding Contacts based on a common pick list value

You'll need to build the query from the Contact Group.

Where is the picklist value being stored? On the Account table or a child table?