Are custom lookup fields searchable with the (All Fields) Search Enhanced Lookup on a Custom Object?

In this example: I have a "Well" (Custom Object) record that has a look up relationship to a "Rig" custom object. If I type in the name of the Rig into an enhanced lookup on a different record it returns no results (I confirmed that the 'All Fields' selection was made) on the lookup search box.

Any ideas?

1 Answer 1


Relationship fields (and picklist fields) are not included in the search. Though the enhanced lookup search covers more than just the name field, the search scope is still limited to searchable fields on the object, which include:

  • Auto-number fields and custom fields that are set as an external ID
  • Email and phone fields
  • Fields of type text, text area, long text area and rich text area
  • Some other fields that are dependent on the object (see Searchable Fields by Object in the help topic)
  • Thanks Shannon. So even if I created some type of formula field to spit out the text of the lookup relational field I am still going to run into the same problem right? Any ideas to make that relational field searchable in some way?
    – Girod
    Feb 27, 2014 at 19:11
  • 1
    Formula fields aren't searched either. But if you have Enterprise Edition or higher, you might be able to use a workflow rule to copy the value from the lookup into a custom text field. Feb 27, 2014 at 21:00
  • Sorry last question... Does the field have to appear on the layout in order for it to appear in the enhanced lookup search?
    – Girod
    Feb 27, 2014 at 21:47
  • 1
    No. It also doesn't have to be visible to the user through FLS -- it's still going to return results. Feb 28, 2014 at 20:56

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.