web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Look-up field filtering

(0) ShareShare
ReportReport
Posted on by 70

Hi all,

I've set up 3 custom entities (Division, sub-division, Group), these entities are industry verticals that break down the trade of a business. I believe i have set up the relationships correctly and created a look-up field in Sub-division and Group.   (sub-division look up to Division,   Group look up to Sub-division)

Essentially, when a user selects a Division, I want the sub-division options to be filtered based on the selected division.

Currently, I have a weird issue where Division is not filtering correctly to sub-division however sub-division is correctly filtering groups.  (see images below)

Division > sub-division (not working)

pastedimage1642641674801v1.png

Sub-division > Groups (working)

pastedimage1642641751248v2.png

From what I can see, the setup is identical across all 3 entities. 

Could anyone suggest what i could have done wrong, maybe in the relationship set-up or the form set-up? A checklist of things to do would be super helpful.

Thanks in advance.

CRM version : 2016 D365 CRM 9.0 on-prem

I have the same question (0)
  • Verified answer
    Vipin J Profile Picture
    1,603 on at
    RE: Look-up field filtering

    Please verify the Show Related record property for Lookup in field property.

    Refer here for searching across multiple tables : https://vjcity.blogspot.com/2021/07/how-to-search-in-multiple-table-from.html

    How to stop showing recent records for lookup fields in UCI : https://vjcity.blogspot.com/2021/07/how-to-stop-showing-recent-records-for.html

    How to search lookup based on other attribute in Dynamic CRM : https://vjcity.blogspot.com/2021/07/how-to-search-lookup-based-on-other.html

  • Suggested answer
    J_C Profile Picture
    70 on at
    RE: Look-up field filtering

    Thanks Vipin,

    Related record property was exactly what I was missing!

    Legend

  • Danny Vargas Profile Picture
    30 on at
    RE: Look-up field filtering

    Hi J_C 

    If this question is already fulfilled could you please select that is already answer?

    Thanks in advance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 117

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 117 Super User 2025 Season 2

#3
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 83

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans