Have a problem which I have also found in FMP 4.1 regarding the accuracy of searches.

Running under Mac OS 10 I use a name and address database of about 1800 records and need to search with multiple parameters. The search looks for fields that contain a single character within a string in one field and consecutive characters in a string in a second field.

Although there are records that match the search parameters they are either not found at all or only some of the qualifying records are found.

Has anyone experienced such a situation or have any ideas? I have deleted records and re-input but the problem still exists.

Hi BrizUK! I just did a test in FM4.0 w/about a dozen records and it seems okay, but maybe I was not searching the same way...

I did a single FIND request using

*te* in one field, and

*o* in another field

Steve

Jobs

was found okay but not others that only satisfied 1 of the criteria. I hope this helps towards solving your riddle...

--ST

Hi Steve T

Thanks for reply which prompted me to look more closely at the problem.

Although fully aware of the need to enclose a character with * when searching within a string this is where the problem arose.

The single character search is set with a script but in specifying the search field contents I had omitted the *

How could I be so stupid?