On 5 May 2011 07:33, André Boey <[log in to unmask]> wrote:
> 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

That's not necessary André.

For starters, the script is being run within the FileMaker context so
the first "tell" statement is redundant.

Also, it's fair to assume that Deb's FileMaker script will be run from
a context where the field "Photo
Catalog::File Path" evaluates correctly so we can use that field
without having to first set a global. (Plus, you forgot to mention
that the script would first need to set the value of the 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.

Sorry to be pedantic, but it's not necessarily as simple as that.
Translating from a Unix- to a Mac-style file path is best done by
using:

POSIX file filepath

For example:

set foo to "/Users/tim/Desktop/image.jpg"
POSIX file foo
--> file "Macintosh HD:Users:tim:Desktop:image.jpg"

HTH.

-- 
Tim Mansour <[log in to unmask]>
Neologica Print & Promotions ABN 63 904 335 408
Certified FileMaker 10 Developer
PO Box K1163 : Haymarket NSW 1240
Mobile 0405 500 846