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.
