Possible to use wildcards in show statement?

[Bill Hunter]

Happy to find forum. I am using FM 4.1 & have a large but simple flat db. Would really prefer to use the show statement within Applescript to make this find:

show every record whose cell 4 = "apples" or cell 4 = "oranges" and cell 1 = " (what I need is the equivalent of !, the duplicate wildcard) "

My question: can this be done?

[BobWeaver]

Try using this format:

code:

---

tell application "FileMaker Pro"

delete every request

create request

set cell 4 of request 1 to "apples"

create request

set cell 4 of request 2 to "oranges"

set cell 1 of request 1 to "!"

set cell 1 of request 2 to "!"

find

end tell

---

A word of advice: using the duplicates symbol in conjunction with other find criteria produces interesting results, so try your search within Filemaker to make sure that you are getting what you really want before putting it into an applescript.