Using Find from drop-down

Discussion created by MikeWile on Sep 1, 2016
Latest reply on Sep 1, 2016 by beverly

I have a field with a drop-down menu. If I enter Find mode and select the first item, 1 MONTH FREE SUBSCRIPTION, it finds only that item. If I select the second item, 1 month subscription, it finds that plus 12 month subscription and 1 MONTH FREE SUBSCRIPTION. At first I had the drop-down based on values from a field but changed that to based on custom values thinking that was the problem. Then I noticed that there were leading and trailing spaces in the records so I reimported the records with a TRIM calculation to remove the spaces. It removed the spaces but it still doesn't find only the second item in the list. This is the only problem in the list. When any of the other values are selected, only those records are found. Any ideas why this is happening?