FM7 - Using container fields

[kschuster1]

I'm creating a database and would like to import pdf forms and store them in the db. I'm looking for an example of using container fields. I may have multiple forms for a given record. I need a way to move between the repetitions - right now I only see one repetition. I also need a good way to open the pdf file. I know I can export the file then view, but would like to automate the opening.

thanks

[edudx]

I'm with you -- looking for a way to view word and excel files directly from a container field in FM, files which are stored both as referenced files (links) and imported entirely. Anyone have suggestions?

[stefanshotton]

Set up a new table for documents.

With Fields-

Document Number

Customer/record number

Container.

Each pdf/doc/ etc is given an autogenerated serial number.

Have a global field set up in original table.

You need to set up a script that copies the record id/no to the global field in your orignal table, then create a new record in the document table, use set field to copy the record id to the new record(in customer/record id).

Then have a script that inserts file into container(insert file).

Set up a relationship between customer id in original table to customer id in document table.

NEW LAYOUT.

Insert a portal(set rows to 5+ and have scroll bar on) that looks at the document table, this will then only show containers for the given record you are in even if there are multiple documents.

As for opening embedded files look at the post OPEN Embedded container files and there is an attached example of how this can be done with no plugin needed.

[edudx]

stefanshotton -- Thanks for your posts. The filemaker site lists a plug-in called "base-it" which was suppossed to add functionality to file opening, inserting, exporting, etc. When I go to the site I get a page full of German text and no obvious links.

Do you know of another container field/file management plug-in?

Clever workaround for exporting/viewing embedded files. For now I'll just keep my files in a directory and reference them.

Thanks for your posts

[stefanshotton]

Troi File plug in is the most popular file manipulation plug in, however for simple move/copy you should be able to use a simple external script.

windows via .bat files, with mac applescript ( i think, not a mac user)