I have created a lookup field with required filter type that filters on specific criteria within the lookup objects. During testing I noted the lookup field only returning 1 value as an option when there are several values (28 potential values) that match the criteria I filtered. How do I make my lookup field display all potential values?
Since you probably want records for this year, not last year, you'll need both 2014 and 2015 in your search string, likewise you would need 2015 and 2016 for next year. Try this:
If you need even more complex requirements, then this interface can almost certainly handle them, eg you could do a query like this:
No there is not. You might be able to get the Metadata API to work for you.
Best Answer
You need to check following points: 1. make sure that you have permission to all 28 records. 2. Lookup Filter criteria is also case sensitive. So please also make sure that all 28 records are satisfying filter criteria. 3. Also When you click on lookup icon only recent records are shown some time. So try to search some record which satisfy filter criteria.