There is one field, which is look-up to Opportunity. Now lets say there are 5 Opportunity records with name Anil.

  • When I put "A" in that search, it shows 2 records,

  • when I put "An", it shows 3 Anil records and

  • when I put "Anil", it shows 5 records.

Why is it happening like this? What is happening behind this look-up search?

1 Answer 1


As you start typing in a lookup field, the results adjust dynamically with records that have matches in the Name field. Records includes recent items, items from your most frequently used objects and items from the current object. To find the correct record enter the full search term to display right matches.

You will see a list of auto-suggested results when you search in lookup field and these instant results are matches for the search term to the name field of the record. Again these results are dynamically displayed. However, if you perform a full search the returned results match the search term to all searchable fields for the object.

Check more details on lookup search of classic and lightning.

Also, see limitation to display all records in lookup search, you can try workaround if you to still want to display all records on opportunity in lookup search.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.