This ought to be the most basic, simple thing you could possibly do, 
so I'm probably missing something obvious.  I want to get the value 
of a particular cell from a record that matches something in another 
cell.

In SQL, something like
select phone_number  from people where name = "Smith"

so why not

tell database "people"
get cell "phone_number of every record whose cell "name" is "Smith"
end tell

-->Object not found

Tried get data, show, find, goto, and so on. Always an error.

Every reference on Applescripting Filemaker I've looked at has 
offered vast detail on how to get field names, table descriptions, 
yadda yadda.  Not a word about just finding data.
-- 

Bill Steele
[log in to unmask]