Applescript FMP5 Multiple Find

[RH Design]

APPLESCRIPT PROBLEM: I need to write an applescript to perform a multiple FIND on a Mac FMP5 database.

For example: To show records whose field "Name" contains "A","B","K", or "N"

(in manual FIND mode I would simply use Command N to add each new criteria)

My starting point is:

tell application "Filemaker Pro"

show (every record in database "myDatabase" whose cell "Name" = "A")

end tell

This successfully shows the "A" record.

Many tries later, I still can't find the correct language to extend the command to show all four records ("A","B","K","N").

It can't be that hard. Can someone please embarrass me?

BobH

[h2o]

Hello,

A simple way to work is working with "requets" and "find".

try this :

set theRequests to {"A","B","K","N"}

tell application "FileMaker Pro"

show every record of database "myDatabase"

delete every request of database "myDatabase"

repeat with x from 1 to count theRequests

set crre to create request

set cell "Name" of crre to (item x of theRequests)

end repeat

find

delete every request of database "myDatabase"

end tell

[RH Design]

JM -- Perfect solution...You have only been registered 4 days

and you have saved at least one project already!!! Many thanks.