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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Is it possible to index the main field from a lookup field ?

(0) ShareShare
ReportReport
Posted on by 188

We have link our opportunities to another entity (quote headers from the ERP). We would like to be able to find the opportunities by searching with the value of the main field from the other entity (it's the quote number). It's set as "searchable", but it's not working. I guess because it's a lookup field and not the actual value of the quote number. Is it possible to make it work? Without having to copy the value of the quote number in a new field on the opportunity, ideally. Thanks in advance for your help ! :)

I have the same question (0)
  • Eiken Profile Picture
    on at

    Hi,

    Is the relationship between opportunity and another entity a many-to-one relationship?

    Would you please provide some screenshots to describe your problem?

    I'm not quite sure where you need to search for opportunities.

  • FrancoisT Profile Picture
    188 on at

    Here is the capture. i'm connecting this opportunity with this quotation (number FRQU-002142) and I want to be able to find this opportunity if it's entering "FRQU-002142" in the general search engine. but it's not finding the opportunity. Is it possible just with this lookup field in the opp ? or should I also have another field with this value in the opportunity ? I hope it's clearer. 

    And yes, it's one to many (we can put one quotation in each opp, and one quotation may appear in several opportunities)

    Capture-d_1920E900_cran-2023_2D00_04_2D00_06-141255.png

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello,

    Open "Quick Find View" of the opportunity entity and add "ERP quote" field to the list of "search" fields.

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…

Neeraj Kumar – Community Spotlight

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

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans