Any way to open a file name specified in a field?

Followers

April 3, 200322 yr

Hi,

We have a number of different filemaker database files being created.

We would like to store the file names in a field in a 'master' database,

and have a button/script called 'open' which would open the filename

specified by the field. Is there any way to do this?

Thanks in advance!!

David

April 4, 200322 yr

yep. try

openurl, file://C:/Programs/FileMaker/Samples/xxx.fp5

should work if your internet preferences are set up right.

April 4, 200322 yr

or you can set up a calculation field call it something like "FP5 Files" that is not displayed. That calculation would be

"location where file is located" & FileNameField

The Result would be displayed in text format Then make you script and all you need in it is

Open Url [No dialog, "FP5 Files"]

3 months later...

July 10, 200322 yr

How does this work with files hosted on FM Server? What URL do I need to open a file there?

July 10, 200322 yr

on win

"server_nameshared_folderfile_name.fp5"

or a full path of a mapped drive

Z:shared_folderfile_name.fp5"

that is if the map letter never (shoud not) changes.

July 10, 200322 yr

Has anyone ever tried to make this work for local files on Mac OS9? I tried this a few months ago, and when I used the FMP5://netAddress/databaseName syntax I got an error that indicated an invalid server (of course there was no server). When I used the file://path/databaseName syntax I got some other error message. I gave up at that point.