Find Record

[Icecold]

I want to find a record in my filemaker database Which has about 5 forms in it.

The name of the Database is FMTEST and the form I want to do the Find is NEWFORM. The field is Called NAME in the fm database that I want to enter my param1 into and then find the record. Then after that record is found then Return the values in these two other fields as strings

2nd step is to return the text that is in Field "PHONE" as X

and Field "CITY" as Y

On run (param1)

tell Database "FMTEST" of app "Filemaker Pro"

Find Record

Set cell "NAME" of Find record to param1

End tell

End run

[Jeff Spall]

Hi, i'm not really an AppleScript wizz, but this has been working for me:

To perform a find and get some info in:

tell application "FileMaker Pro"

show (every record of database "mydatabse" whose cell "recordnumber" = anAppleScriptVariable)

set cell "myfield" of current record of window "mydatabase" to "OK"

------------------

or to send a variable value to the field:

set cell "myfield" of current record of window "mydatabase" to thevariable

------------------------------------------------

to get data from Filemaker into an Applescript variable:

set TheApplescriptVariable to {cell "FileMakerField" of current record of window "mydatabase"}

------------------------------------------------

hope this is OK

jeff