Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Lookup for Product Family not all the Products

Posted on by 343

Hi all,

I am a developer and new to Microsoft Dynamics CRM. I want to know that if it is possible to make a lookup for only Product Families in the product catalog? I want all the product families in the lookup not all the products. If someone can help or give suggestion? 

Thanks.

*This post is locked for comments

  • Verified answer
    Shidin Haridas Profile Picture
    Shidin Haridas 3,497 on at
    RE: Lookup for Product Family not all the Products

    Hi, this is possible through the following:

    Approach 1:

    1. Create a new view in CRM which shows only Product Families.

    832326.Capture.PNG

    2. On your form, open up the lookup field properties by double-clicking on the form, then scroll down in the Display Tab.

    Set the Default View to the newly created system view, and turn off other views.

    Approach 2:

    If this does not seem to satisfy the criteria, then you may have to implement a lookup filter on form load using addFilter.

    What it does is puts a filter on the lookup field to show only select set of records.

    See the link here: https://msdn.microsoft.com/en-us/library/gg334266.aspx#BKMK_lookupControlMethods

    But this approach requires some knowledge of form scripting using JavaScript.

    Cheers!

  • Verified answer
    Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: Lookup for Product Family not all the Products

    Hi,

    You will need to create a new view to look at Product Families only.

    3542.Screenshot_5F00_1.jpg

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans