AnsweredAssumed Answered

No results are found on a search performed on a Drop Down list.

Question asked by CoreyRice on Mar 13, 2014
Latest reply on Mar 14, 2014 by philmodjunk

Title

No results are found on a search performed on a Drop Down list.

Post

     I inherited a database with my new job and it was very dirty with multiple fields being used to store one type of information. I'm working on consolidating everything to one field with a drop down list so it can't be edited and thus lost. This field was previously a pop up menu so there are some records with data not included on the list.

     Now when I perform a search, no matter what selection I make from the drop down menu, the search comes back with zero records found.

     Any idea on what the problem might be?

Outcomes