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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Lookup field displayin...
Microsoft Dynamics CRM (Archived)

Lookup field displaying results from another lookup field.

(0) ShareShare
ReportReport
Posted on by Zylawy

Hello,

I have 2 fields one being Colour and one being Finish.

If I have Colour: Arctic White, I want my Finish field to only show the options: Satin, Polished and Silk. But if I select the Colour Nero I want it to only show the finish: Satin.

I have created a many to one relationship from Colours to Finish, but how do I configure the Filter Criteria in the view?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,628 on at

    Hi,

    You can refer to below post. It is under the lookup properties called "Related Records Filtering"

    www.powerobjects.com/.../how-to-use-dependent-lookups-for-dynamics-crm-201320152016

    Thanks

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    Hi,

    It seems you have made wrong relationship between colour and finish. It should be 1:N and then based on your colour selection can filter below lookup to show only options which is relation to current colour parent (you can set it under related record filtering in lookup property)

    Hope it will help.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Dear Zylawy

    As Mahender kindly noticed, I also think your relationship is wrong.

    Your relationship says that many colours should have 1 finish. I suspect that you're trying to give 1 colour multiple finishes, which makes it an 1:N relationship instead of a N:1 relationship.

    Try changing the way your relationship behaves and report back in this post if anything changes.

    Kind regards

    Giani Noyez

  • Zylawy Profile Picture
    Zylawy on at

    Thanks for the information. I was able to get that part working. The current issue I'm having is connecting multiple finishes to several colours. I created a many to many relationship but the lookup field I created only allows me to select one option.

  • Zylawy Profile Picture
    Zylawy on at

    Was ale to solve this by creating a many to many relationship. Thanks for all your help!

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Shidin Haridas Profile Picture

Shidin Haridas 2

#1
SA-08121319-0 Profile Picture

SA-08121319-0 2

#1
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans