Bit of a cheeky one this but I am trying to get an Applescript to take a SKU number from a field in a Filemaker database and use this information to find the the graphical image of this SKU in a Cumulus database. The Filemaker part works fine with putting the SKU number into the variable but I can't get the Cumulus part to work!

This is the script I have so far.

tell application "FileMaker Pro"

go to database "BOM.fp5"

go to layout "BOM"

set SKU to get data cell "SKU" of current record

end tell

tell application "Cumulus Single User"

open "Filemaker Server:

You should use tell statements for the databases too.

tell application "FileMaker Pro"

--tell fm to do something

tell databases "database name"

--tell database to do something

end tell

end tell

tell application "Cumulus"

--tell cumulus to do something

tell database "imagedatabase name"

--tell database to do something

end tell

end tell