I have Policy, Plan and Company custom objects where Company 1:N Plan 1:N Policy through lookup relationships.

When creating a new Policy I click on lookup Plan, then I attempt to search by the Company name with All Fields selected but no results are retrieved. This is strange since it works in another org.

So far I've checked that both orgs have enabled Enhanced Search, and all 3 objects have a tab although only Policy tab is displayed by default.

What am I missing? thanks

  • Did you check if the profile has access to the objects itself. go to the user profile and in the custom object CRUD settings check if the profile has atleast read access to plan and company objects.
    – Rao
    Apr 24, 2014 at 2:08
  • In both orgs I'm using system admin and just to be sure, yes all three objects have CRUD access Apr 24, 2014 at 2:12
  • did you check if there are there lookup filters
    – Rao
    Apr 24, 2014 at 2:13
  • Plan and Company are selected in Plan/Search Layouts/Lookup Filter Fields Apr 24, 2014 at 2:16
  • can you come here: chat.stackexchange.com/rooms/4337/salesforce
    – Rao
    Apr 24, 2014 at 2:25

1 Answer 1


I'm realizing that the org where this is working has a text field in Plan that is compounded of Company name and Plan name (this compounded field is to avoid Plan dupes in same Company). And the org where this is not working has the compounded field of Company ID and Plan Name, thus company name ain't searchable.

And is understandable that in one org it does work because the company name is embedded in a text field of Plan while on the other org it is the company Id not the name which is embedded.

Thanks to @rao for helping me bounce ideas to figure this out

  • Thats ok :), happy I learnt something new.
    – Rao
    Apr 24, 2014 at 2:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .