Teutonic_Night Posted December 8, 2005 Share Posted December 8, 2005 I have a database that was updated from, ahem, FileMaker 4 to FileMaker 8. The upgrade seemed to go fine. However, one of my users has just encountered an odd behaviour in Find mode. There is a field that is set to display as a drop-down menu containing values from a Value List. She is trying to find all records that have a specific value in this particular field. When she does the Find, she gets the results that no records match the request. However, I *know* there are records that have the particular value in that field. In fact, 727 records out of 4350 have that value. If I select "Find Matching Records..." on a record that has this value in this field, I find all of the matching records. If I select Find, then choose the value from the list, I find no records. Any suggestions as to what's going on here? Link to comment Share on other sites More sharing options...
SlimJim Posted December 8, 2005 Share Posted December 8, 2005 Assuming that choosing a value from the value list is actually dropping that value into the field then the obvious (but somewhat unlikely) answer to your question is that the values in the value list do not match the apparently same values in the field. Have you redefined the Value List since the update? Is the VL defined by the values of the field you are searching or by some other field? If they are not defined by the field you are searching it might be worth defining a new VL from that field's values and see if that gives you the same problem. Link to comment Share on other sites More sharing options...
Teutonic_Night Posted December 8, 2005 Author Share Posted December 8, 2005 Well, I tried creating a copy of the field on the same layout, only setting it to be an Edit Box instead of drop down. Typing in the value I want to find doesn't work, though Find Matching does... It seems that maybe the information stored in the field is causing problems. If I type in a portion of the data, the find seems to work. The data contains a "#" sign, though, and it seems like if I type in the "#" sign or any characters after it, the search fails to find any results. Link to comment Share on other sites More sharing options...
SlimJim Posted December 8, 2005 Share Posted December 8, 2005 The # sign is a wildcard and stands for any digit. In order to find a # you have to look for # Link to comment Share on other sites More sharing options...
Teutonic_Night Posted December 8, 2005 Author Share Posted December 8, 2005 Hmmm.... if that's the case, I wonder why the Find won't work. Unless the wildcard "#" can't be the "#" symbol itself. Here's the text that's being searched for: 2006 Furn. Catalog #0024280 Searching for that string by choosing it from a drop-down menu does not work. Searching for it by typing it and surrounding it in quotes does work. Link to comment Share on other sites More sharing options...
comment Posted December 8, 2005 Share Posted December 8, 2005 The wildcard "#" is looking for a digit at the position of the wildcard. If you had records with "2006 Furn. Catalog 10024280" or "2006 Furn. Catalog 20024280", then 2006 Furn. Catalog #0024280 would find those. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6707 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now