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

[dtrusty]

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

[cjaeger]

yep. try

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

should work if your internet preferences are set up right.

[jsaltzman]

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"]

[damyena]

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

[Leb i Sol]

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.

[BobWeaver]

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.