hey great, thanks! got it working easy, never thought to use Open
URL to open files, but of course it makes total sense.
SoundFileField is a calculation (ID_name_title), so i don't even need
to bother with the insertion step.
Open URL "file://Macintosh HD/Users/UserName/Folder/" & SoundFileField
the only thing i can't do with this method is set which application
to read the file with; the files will be created with Nuendo, but for
this function i want Peak to open them. that would only be possible
-- it seems -- by setting the system-wide preference to open file
type A (Nuendo) to open in programme B (Peak).
i tried using Send Event (Bring Target App to forefront) to override
the default prog set to open the file, but i'm sure you know that
this doesn't work :-(
You can do it using Open URL ( field with path & file name )
The tricky part is to get the path right ala FileMaker: when I'm in
trouble I define a container field, insert a file (reference only)
in it and then define another calc field, unstored, text result =
the container field: the field will return the path to the file the
way FileMaker wants it
Last but not least: FileMaker wants it in a different way depending
on the platform (Mac or PC), so take also that into account