Wednesday, October 21, 2015

Show N:N relationship in Advanced Find

You have a many to many relationship between two entities A and B but you can't see it in the Advanced Find ?
Here I'll show you how to display it.

First of all, if you are in CRM 2015 open the relationship and ensure the Searchable attribute is set to Yes.
Then, the related entity's Display Option must not set on Do not Display but on Custom Label or Use Plural Names.
For exemple if you are on the entity A and you want to display the N:N relationship with entity B, you must set entity B's Display Option to Custom Label or Use Plural Names. And vice versa.
Edit Relationship Dialog

Publish your customizations and... tadam ! you see in the Advanced Find the relationship.
Advanced Find

Great Scott !!