Google "filemaker container youtube"
Home > Using FileMaker Pro > Adding and viewing data > Using data in container fields
I'm guessing that you are using Filemaker 12.
If the files are inserted into a container field with Insert File and the "store a reference" option specified and the container field object on your layout is NOT optimized for interactive content, you can double click the container field to open the document in the OS system's specified default application for that file type. After editing and saving changes, they will be retained as your container field no longer embeds a physical copy of the file, it stores the filepath to the actual file instead.
The main issue for you is that drag and drop does not insert the file with "store a reference", it embeds the file instead. Here are two options for handling that issue: 1) A script could be used to export the file to a specified directory and then re-insert it into the container field with the Store a reference option. 2) It's also possible to write a script that exports your embedded file to open it at a specified location and then a second script can use the same file path and name to re-insert the file. You can add a button to your layout labeled "Save Changes" or some such to accomplish that trick.
Note that some storage options and data formatting optimization options (fileMaker 12) keep the double click from opening your file so you may have to go with the second option. Also, the "Optimize for interactive content" option does not work for container fields in a portal so if you need that feature, we may have to get a bit creative to make that aspect functional in conjunction with your portal.
There are key details, however, that can keep a file from opening when it is inserted into a container field:
1) It must be inserted with the "store a reference" option.
2) It must be inserted with the Insert File menu option. For reasons unkown, this doesn't work (Not in 12, not in earlier versions) if Insert Picture were used to insert the file into the container field.
3) With FileMaker 12, you have a new limitation in that the container field cannot be optimized for interactive content.
If you do not select "store as reference" you cannot open the file by double clicking the container. This is true for earlier versions of FileMaker as well as version 12. When you double click the container, FileMaker passes the location of the file to your computer's operating system and causes it to open the file. If you do not use Store a reference, there is no file path to send to the operating system. (But this doesn't explain why "store a reference" files inserted as a picture cannot be opened--never have figured out the why to that limitation.)
Files inserted with the store a reference file have to be stored on the server and inserted from there. They must be located in a folder that is shared and accessible to all clients that need to see/open that file with the same file path stored in the container file. This requires mapping/mounting the shared folder with the same filepath as that used in the container file.
It often helps to set up a script where a file is first inserted without the store a reference reference and then the script uses export field contents to export the file to the shared directory and then re-inserts it with the store a reference option from that shared location.
It's also possible to open any file inserted into a container field by all of these methods if you use Export Field Contents to export a copy of the field to a specified location on the user's computer--such as the temporary items folder. The main limitations to this approach is if the user needs to open the file, edit it and then save the changes back to the copy in the container field, the edited copy on the user's computer would have to be re-inserted after the edits are made and saved.
Home > Designing and creating databases > Creating a database > About planning a database
A well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.Follow these general steps to plan a database:
Relational Database Design 101 (part 1 of 3): Designing a Flat File Database
Relational Database Design 101 (part 2 of 3)
Relational Database Design 101 (part 3 of 3)
LIST OF FILEMAKER LINKS
The White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Free unlocked templates
By Richard Carlton Consulting
Starting Point - Contacts | Accounts | Calendar | Estimates |Invoices | Projects |Products | Staff etc.
Donations - Accounts | Contacts | Donations | Reporting | Prefs
Data4Life - Contacts | Calendar | Projects | Prospects | Journal | Goals
RCC Blog -
By yzysoft.com Contacts | Products | Invoices | Letters
Sample Database -
Filemaker's Online Help Pages
FMP 12 http://www.filemaker.com/12help/index.html
FMP 11 http://www.filemaker.com/11help/index.html
FMP 9 http://www.filemaker.com/9help/index.html
Hints, Tips, and Demo Downloads FMP version 6 thru 12
If you use Insert File and select the "store a reference" check box. There's a good chance that you can open the file by double clicking the container field.
There are data formatting and storage options, however, that can interfere with that behavior if they have been specified for your container field:
"optimized for interactive content"--if that has been specified for your container field on a given layout, you won't be able to open the file with a double click on that layout.
External Storage specified for the contiainer field, will also prevent this from working.
Export Field Contents, however can be used to open the file for all possible insert/formatting/storage options that might be specified for that file and that container field.
Why not try to build a 3rd party Word viewer to help open and read word documents in the container? You can google it and select one whose way of processing is simple and fast to help you with the related work. It will be better if it is totally manual and can be customized by users according to our own favors. Remember to check its free trial package first if possible. I hope you success. Good luck.