I have a project tracking table with a "PO #" field (text, indexed).

When I try to perform a find using part of a PO#, I get a "no matching records" error message, even when I know that is false.

For example:

Let's say I have three records with the following PO #'s:

03829-3918MID

57265-4815MID

68137-5843MID

If I perform a Find and type MID into the PO # field, I get the "no matching records" error message.

Why does that happen? It doesn't seem like that should be an issue.

Shouldnt you be finding for *MID

Does the "*" have to be necessary? I have users who either will forget or won't know to use that character when performing a search.

http://www.filemaker.com/help/03-Finding%20sorting4.html

The default Filemaker find (with no special symbols) is for words that start with ... There are no words that start with MID in "03829-3918MID".

If your users don't know how to use the more advanced search features, provide them with a scripted interface that does it for them.