function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
clouduserclouduser 

possible workaround for lookup filters

We have a junction object ABC with a custom field i.e. Year (Picklist value) and we also have another field i.e. Branch (Text). This object has a lookup relation to other 2 custom objects i.e. BCD and CDE. Those objects also have same picklist fields and text fields. We need to make sure that we show the lookup results based on Year and Branch. Need to create the lookup filters criteria from the Junction Object to other related objects. Text field is not supported in lookup filters from source object. Are there any alternatives? Let me know your thoughrs....
https://help.salesforce.com/HTViewHelpDoc?id=fields_lookup_filters.htm
RamuRamu (Salesforce Developers) 
I cannot think of any other alternatives other than changing Branch data type to picklist assuming there are only a few set of Branch names that are always used. 
clouduserclouduser
Unfortunately, we don't have chance to make it as picklist because we have more than 2000 entries.