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

Announcements

No record found.

News and Announcements icon
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

  • Verified answer
    Vipin J Profile Picture
    1,603 on at

    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

    Thanks Vipin,

    Related record property was exactly what I was missing!

    Legend

  • Danny Vargas Profile Picture
    30 on at

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 109 Super User 2026 Season 2

#2
Syed Aqib Raza Profile Picture

Syed Aqib Raza 88

#3
ParthPatel249 Profile Picture

ParthPatel249 84

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans