Many to Many

May 8, 2012 at 9:05 AM

I have 2 entities, contact and account opening application, with a many to many relationship between them. A contact can apply for as many accounts as he want and an account can have as many holders (contact).

I want to get all the account holders (contacts) for a particular account opening application. In the query designer, I choose ContactSet as my entity then I choose the many to many relation. In the filter criteria I am expecting to see the account opening application fields however I am seeing the contact fields.

How can I get all the contacts? Does it have to be a 2 step process; get all the contact guids then get the contacts?

Best regards,