Deb,

Add a Perform AppleScript step to your script that does this:

tell application "FileMaker Pro Advanced"
         tell database "Database Name"
		tell table "Table Name"
			set filePath to cell "global Field Name"
		end tell
	end tell
end tell

tell application "Adobe Photoshop CS3"
	open file filePath
end tell

where filePath is a Mac-style colon-delimited path to the image that  
you pass to AppleScript through a global field. If the path is not a  
Mac-style path but a Unix-style one, you'll have to use Substitute to  
replace the slashes with colons.

Andre

On May 4, 2011, at 14:08, Deborah Tinsley wrote:

> Hey all,
> It has been a long time since I've posted.
> I have an image DB on my Mac (OSX - 10.5.8). I'd like to be able to
> open images from the database in Photoshop (CS3). If the images were
> saved using Photoshop, there is no problem, but some were saved using
> other software and my scipt opens those in whatever other software was
> used (primarily Preview or Nikon Scan). If I open the image up in
> Photoshop and save it, it opens up in PS, but I have thousands of
> images.
>
> The script I used was "Send Event" using the Document setting, I told
> it to open the image using the filepath name:
>
> Send Event ["Adobe Photoshop CS3"; "aevt"; "odoc"; Photo  
> Catalog::File Path]
> Perform Script ["open image"]
>
> I had to add the "open image" or it wouldn't open images that were not
> saved in Photoshop.
>
> Any ideas?
>
> Deb
>
>
>
>
>
> Deborah Tinsley
> Visual Resources
> Kansas City Art Institute
> [log in to unmask]
> 816.802.3395