Open document from container field

[LuckyMe]

Let's say I inserted a MS Word document into a container field.

How do i do to open this document within FMP7?

Any advised?

Thanks

[Michael Myett]

This is a fairly tricky area in FileMaker, here is the simplest case.

Create a script that exports, then opens your word document.

Export Field Contents [ tableoccurance::fieldname; "filewin:/C:/Windows/Temp/worddoc.doc" ]

this creates a copy of your file in your windows temp directory

you can make this any directory you like

Send Event [ open document/application; File Name: "filewin:/C:/Windows/Temp/worddoc.doc" ]

[ Bring application to foreground ]

this opens that copy in word

If you make any changes to this document, you will need to run an additional script to import the changed file back into FileMaker. You didn't open the file from within FileMaker, you saved and then opened a copy of the file.

Insert File [ tableoccurance::field; "filewin:/C:/Windows/Temp/worddoc.doc" ]

this imports the recently modified file back to FileMaker, remember to save any changes to the document in word first

use some error trapping to make sure you are viewing the correct record before you import the changed file back in to FileMaker