I have set a number of fields in my table for filtering, but one filter is behaving strangely. The field has a text description of the type of music. There are a dozen or more values that could be in it, but two of the possible values are "Classical" and "Classical(D)". Choosing to filter for Classical also selects the Classical(D) records. Choosing to filter for Classical(D) gets zero records (and there are hundreds of them in the table). Are the brackets, () causing the problem?
Also, in the pulldown for filter choice, all the filters have one entry listed that's just a number (no value beside it). In fact, this is the filter selected when the application starts. I thought this might be records with null values in that field, but this filter choice seems to select every record in the table.