"Find" tool malfunction in FMPro 8.5

Posted on 2014-03-20
Medium Priority
Last Modified: 2014-03-21
Good Afternoon,

  I have a database that I created in FMPro 8.5 Advanced.  In it I am using 4 finds which all seemed to be functioning correctly.  Because of how the person who is entering data was putting in the information, I changed how one of the drop downs lists each item in its list.  Since I have done that I am unable to do any finds for that list with the exception of (2) of the items in the drop down.  All of the characters are an exact match, and I have tried to delete the drop down list and recreate it, and type character by character in the find.  Nothing working.  Box pops up saying that I need to Modify my Search.  

  Any ideas?
Question by:bobrossi56
  • 3
  • 2
  • 2
  • +1
LVL 25

Expert Comment

by:Will Loving
ID: 39943915
Well, it's kind of a long shot, but I would check the field type and see if it's set correctly, presumably to Text. If it's set to number,  you might not get what you expect when you do a Find.

Expert Comment

ID: 39944045
What do you mean when you say you changed "how one of the drop downs lists each item in its list?"  What in particular did you change?

Expert Comment

by:Peter Harris
ID: 39944070
I would put a second copy of the same field on the layout (or on a test layout) and format without a pop-up or anything, just as editable text.

This will help you to see exactly what is in the field on each record.

Remember the default searching in FileMaker is from the start of each word (without using wildcards etc.) For example If the text in the field is TheWidget then searching for Widget will not work.

It may also help to go click in the (plain editable) field and choose Insert > From Index... which will list all the things that have been entered in all the records. This may show you that some entries are slightly different to others perhaps.
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions


Author Comment

ID: 39945175
To explain better, I changed the the actual word that was input.  In other words I initially setup the field as Mill #1, Mill#2, etc.  Once the user started entering data I noticed he was using fuller names of mills such as Bonding Mill #1, Rolling Mill #2, etc.  All I did was redefine what was in the Value List.  

  I have tried both other answers to no avail.  I am still able to Find two different Values from the list, but none of the others.  I did notice some entries slightly different by inserting From Index, but even those entered correctly still come up with "Modify Search Results".
LVL 25

Accepted Solution

Will Loving earned 2000 total points
ID: 39945238
The "Modify Search Results" simply recreates your most recent Find entries so that you can modify them for refining your search. Try performing Finds are shorter versions of the names, such as just "Rolling" or just "Bonding".  It may give yo more than one result but it might help narrow down the issue.

Are you entering your search criteria directly or in quotes? Putting quotes around it restricts the Find the string within the quotes. If you are using quotes and not typing it correctly it may not find the values. Be aware too that the # symbol has a specific meaning in FileMaker's search operators. If this field is going to be searched on a lot you might want to consider avoiding use of the # symbol. (You can use the "Replace" function to replace all instances of a specific value with something else, e.g. Replace all instances of "Bonding Mill #1" with "Bonding Mill 1"

Try a search for all records with any value by using the ampersand character *  See if the number of records with values is correct and that you can actually see all the values the user has entered or look at the records in a List or Table view that contains the search field to see if there is anything unusual about the entries.

Finally, if you're still having problems, post an example file with some fake data in it. I'm guessing if I can see the file I'm know exactly what is going on in short order.

Expert Comment

ID: 39945261
Do you see your old entries when you use Insert-> From Index? (Mill #1, Mill #2, etc.)  If you change the values in the value list, that won't change the old data - you have to replace those yourself. If you see the old ones in Insert->From Index that means you still have records using the old list items.

If this isn't your problem, you may have a corrupted index. Try this: go into Define Database, and find and click on the field that contains the mill data we're talking about and click on Options. In the Storage tab, change Indexing to "None." Then OK your way all the way back out to the main file (I generally tell people to then close and reopen the file, just to make absolutely sure they're out), and then go back into that Options page in Define Database and turn the index back on.

Author Closing Comment

ID: 39945441
The # symbol was the exact problem.  Once we started doing finds without the # symbol everything was found cleanly.  Thank you very much for the solution.  I will be making a note to get rid of the # symbol throughout the database.

Expert Comment

ID: 39945541
If getting rid of all of them is a problem, remember that you can simply surround the find criteria with double quotes, e.g.:
"Bonding Mill #1"
instead of:
Bonding Mill #1

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question