I have filemaker Pro Advanced 8.5 for the mac on OSX Leopard. I would like to know how to make it so my numerical search automatically does a wildcard search for any files that contain the number set I enter. For instance, if I want to search for Item # 345 and I do a search in the "Job" field for 345, I want it to show me all the records that contain 345. I want it to display 345.5, 2345, 21 345 (with the space). Some of my job numbers have notes referring to the old quote like "09.345.6 (see also 08.456)" Right now I have to do *345* to accomplish what I want. Please forgive this basic question

-- Steven

noone knows how to make a field always do a wildcard search for anything before or after what you type in as the keyword or number to search? I just want to be able to enter 345 and have it find anything with 345 in it.

Edited September 21, 200916 yr by Guest

What's wrong with *345*? When you want to do something "automatically" you usually need a script.

noone knows how to make a field always do a wildcard search for anything before or after what you type in as the keyword or number to search? I just want to be able to enter 345 and have it find anything with 345 in it.

Sure it can be done.

Use custom menus to replace the Perform Find command with a script that checks for anything entered in the field and if there is add *s before and after the text, then performs the find. It would want to check there there weren't wildcards already entered so the text doesn't get multiple *s added.