Dynamics CRM Consultants Explain How To Filter Sub Branch Lookup Field Value in CRM

In this blog Dynamics CRM consultants are sharing a step-by-step guide to explain how to filter another lookup field value based on one Lookup field value. In this Lead entity, they are having two fields Branch and Sub Branch and you will learn how they filter Subbranch based on Branch field.

Based on one Lookup field value, how to filter another lookup field value.

Requirement – In my Lead entity we have two fields Branch and Sub Branch and we need to filter SubBranch based on Branch field

To achieve this, we have to follow some steps:

Step 1 – we have to create two new entities Branch and Sub branch from

Setting–>Customization–>Default solution–> Create new Entity

Step 2 – Create Data in Branch entity for e.g. you can use country names like (India, United Kingdom) these are branches of the company which are denoted as country wise.

Then every Branch should have sub branches, we need to create the data for Sub branch entity also.

Step 3 – Before creating the data in sub branch entity. Firstly, we need to create a field namely MainBranch (DataType -Lookup) in Subbranch entity which will locate your Main entity Branch.

Step 4 – After this step, you have to create the data for branch entity.

Below image displays the same:

crm1.jpg

When the branch data is created then you have to create Subbranch data.

Below image describes the same:

crm2.png

Step 5 – After this step create two new fields in Lead entity named as Branch and Subbranch (DataType- lookup).

Below images describes Branch and Subbranch field.

crm3.png

crm4.png

Step 6 – Add these two field’s in the lead entity information form.

After following all the previous steps, the main lead form will look like this.

crm5.png

Then according to the requirement, we need to filter Subbranch data based on Branch selection.

i.e If Branch value is selected as “India” then Subbranch field will only display “Mumbai” or Branch value is selected as “United Kingdom” then SubBranch will display the value “London”.

For this, we have to set the field properties.

Step 7 – For the field properties follow this path

Setting–>Customization–>Lead Entity–>Form–>Lead Information–>

crm6.png

Now, Double click on Subbranch field, a new window will be open, it will be display field properties.

crm7.png

Step 8 – According to the image, we have to click on the first tab “Display”, then the property is “Related record filtering” is displayed. Click the check box (Only show record here) and Additional Properties is Display search box in lookup dialog is checked and default view is Subbranch lookup view and in view selector chooses Subbranch Lookup view, click the OK Button. Save the form using Save button then publish the customization using publish button.

crm8.png

Step 9 – Go to sales->Lead-> New (for creating new Lead)

crm9.png

When you click on new button a new Lead Page is displayed. Here you have to fill all the mandatory data.

Below image displays the same:

crm10.png

When you select the Branch name as “India” then SubBranch should be “Mumbai”.

All the steps written here should be followed by you for best results. If you have not understood any point discussed in this post, ask CRM development consultants India in comments. They will answer you shortly.

Task Accomplished.

Happy Reading

jameswarner

James Warner is an highly skilled and experienced software and mobile application system development manager at NexSoftsys. He has wide experience in IT industries to develop creative business system based on Java, .Net, Python, iOS, Magento and Android.His broad technology knowledge inspire him to face complicated projects. He is working with Healthcare industries, Telecommunications, Banking and finance IT sector to produce high security and user friendly business system.

Leave a Reply

Your email address will not be published. Required fields are marked *