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