Step By Step Related Record Filtering in MS CRM 2011

As we know MSCRM 2011 provides OOB related lookup filtering feature. Let’s take an example I have two lookup in opportunity form, Customer (Account) and Contact. and I want to filter primary contact lookup based on Account selected. I want to only show only those contacts where Parent Account is selected account.

I have created two accounts Test1 ,Test2 and created three contact where two contacts related to Test1 and one contact
related to Test 2.

Before Filtering Setting

I have selected Test1 account and when I will clickon Contact I will get below lookup window

You can see here I can see all contact which is related to Test1 as well as Test2. So let’s set filter criteria

  1. Select Customize Tab and select Form.
  2. Double Click on contact lookup.
  3. Set Related Record Filtering like below

4. Save and publish your changes.

Next time when you will select contact lookup you will only get related contacts like below

After Filtering Setting

Enjoy !!!


Leave a comment

Filed under MS CRM 2011, Step By Step MS CRM 2011

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s