Overview:
A user tries to populate a Lookup field with a value.
Example: On a product record, a user clicks on the magnifier icon next to the Parent Product field. The Lookup search appears as:
The name of the Parent Product is New Dog Vaccine 2017:
- If a user enters New, the search returns results.
- If a user enters Dog Vaccine, the search does not return results.
Root Cause:
This is expected behavior when searching in lookup fields. A Starts-With type search works without wildcards. Contains type search works only with wildcards.
Solution:
If using a Contains type search in a Lookup field, add wildcards to the search term.
Example: an asterisk (*)
Related Documentation:
CRM Help Documentation: Configurable Lookup Filters and Layouts
Thank you