I have a lookup field on Account to a custom object. The lookup dialogue, allows me to search on the record's Name. However, I want to search on one more field. Is there a way to search from a lookup dialogue to more fields?
I have a lookup field on Account to a custom object. The lookup dialogue, allows me to search on the record's Name. However, I want to search on one more field. Is there a way to search from a lookup dialogue to more fields?
Best Answer
To get autocomplete results in lookup field, you can only perform search on first two fields mentioned in Search Layout of the lookup object (parent) and this can only be done for some specific field types mentioned below for custom objects.
To get results on lookup dialog box (by clicking on enter), then you can perform search in all the following types of fields for Custom Objects.
For all other objects, you can refer this link
If we add formula fields to perform search on unsupported types, it works on recently opened records in autocomplete but not full search.