Thanks for the clarification, Tim. I need to work on integrating my AppleScripting with FileMaker a little better. ;-) Andre On May 4, 2011, at 18:20, Tim Mansour wrote: > 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