+ Start a Discussion

Wildcard search not working in master detail lookup

When logged in as an user other than the system admin account and click upon the magnifying glass of a master-detail lookup in a new form I get the standard lookup window.

However if I specify the '*' wildcard as a search parameter then nothing is returned.

If the first couple of characters of known 'master' record is entered, then the matching records are returned in the search results.

Logged on as the system admin, then the '*' wildcard works as expected.


Any ideas?






This looks like your OWD settings. If OWD settings for Account object is Private and non admin user is below the Hierarchy of admin then he can see any records. Please change your OWD setting for Account object to Public Read Write and then try.

Since Adminc can see all the records it returns some records.