Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Creating a lookup to a custom entity - looking up product numbers/names from order field

(0) ShareShare
ReportReport
Posted on by

Hello, 

I am fairly new to the CRM world and have found the community on here very useful however I am struggling on this subject.

I am working on cases - customer service.

On the order entity we have a view of products that are within that order. This view is only populated with products once the order is saved/processed.

On my cases page I have a related look up for 2 fields. ( 1 field for orders and 1 field for invoices ) - only brings up related orders/invoices depending on what company is selected.

I am wanting to create another lookup that will show the products related to the order once its selected. No products are currently stored on our CRM and are written across from a 3rd party platform. As i mentioned they are only populated on a view once a order is processed.

At the moment it is a manual process as the CSR will find the order number whilst creating a case but will have to search that order number within the order entity (on a new tab) to note down the product numbers.

Is there a work around or a way I can allow CSRs to search for a product number from a order number whilst creating a case? (I hope the question makes sense).

*This post is locked for comments

  • RE: Creating a lookup to a custom entity - looking up product numbers/names from order field

    Hi Jason, It can be in the form of a subgrid or a lookup field. I just need the option for the person creating the case to lookup the product/product numbers from that particular order?

  • Jason M. Cosman Profile Picture
    Jason M. Cosman 5,234 on at
    RE: Creating a lookup to a custom entity - looking up product numbers/names from order field

    Hello Tervinder;

    Just want to make sure it's clear what your asking for. On the case entity you have a lookup to the related order entity. You want when a case is being created the user selected the order it would show like a subgrid with all of the products that are associated to that particular order?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans