Open File's only use is to open other filemaker files.
Open URL will work as you've described. You can also insert these files in store by reference container fields which also stores the file's file path in a field you can double click to open the actual file.
Other developers use a third party product called SuperContainer which you can look up with a web search if you are interested.
Thank you for the swift reply.
Yes, we use open URL to open other files. Everything is fine now, except I need to enter the full data file name to the database manually. It will be endless tasks and will have a lot of mistake. That's why we need to have some user interface.
"insert these files in store by reference container fields which also stores the file's file path" - Due to huge to data file size, we want to store the file path only. We do not want to store the file inside the filemaker database.
I am new for the file maker, if it is possible, please have a little more detail about your solution. Thank you.
When you store files in a container using the "store by Reference" option I am describing, you do not store the actual file in the container--just the file path which is what you have requested here.
Define a container field, given the multiple files you've described I'd define it in a related table for greater flexibility.
Place this file on a layout, enter browse mode, click on the field and choose insert file from the Insert Menu and insert the file, being careful to click the store by reference checkbox. To open the file, just double click the field--no script required.
Thank you so much. I implement it and it works excellent. New question - we will have thousand files. We will use container to store all files. Of course, "store by Reference only". I would like to have a script which go through all of records and container fields automatically when necessary. And check each file is exist or not - it means the container file is valid or not. Because, we might rename or remove file some times and we might forget to change the container record. How can I implement it?
I suggest investing in a file "plug in" that lets you list the contents of directories. You can extract the filename and file path from the container field and use that with the plug in to confirm that a file exists.
To see the filepath in your container field, define a calculation set to return text and enter the name of your container field as the sole term in this calculation field. Put it next to your container field on your layout and insert a few files. That'll show you what's really inserted when you insert a file. You can use text functions and functions such as GetValue to extract portions of this text from the container field in order to do this.
If you are using windows, the mooplug offers this capability and is free--just google that name and you'll find the download page and more info about it.
This is also where you might research supercontainer to see if it meets your needs as it offers some extended capabilities in this area.