Search returning no results
I am using Filemaker 8 to keep track of festival submissions. Each title is marked with what year it was submitted. The problem I am having is that when I search for a specific year I keep getting the message that there are no results that match my request, even though I know there are.
I am searching a number field that contains a value list based on the corresponding field in our "festival" table. I am inputting the year (I have tried using the drop down menu from the value list and inputting the numbers manually) and coming up with nothing. I cannot for the life of me think of what I could be doing wrong. Any thoughts?