Jump to content

Odd Find Behavior


Teutonic_Night
 Share

This topic is 5770 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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

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

This topic is 5770 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.