Attach Excel Files

[ceprogram]

I would like to be able to attach a related individual Excel file to inddividual records in my database. Is there a way to do this?

[Fenton]

In FileMaker 7 there is a way to embed or reference a file of any type in a FileMaker container field. But not in 6, not Excel files. So it's not going to be "related" in the FileMaker sense of related records, only in the general sense.

You can use AppleScript, or the Troi File plug-in (or similar) to set a text field to the full path of an external file. Then you could use that path to open the file.

With AppleScript you could go a bit further and create an "alias" file, linked to the original, and store it in a known location. That way you could move the original file (but not the alias file, unless you can calculate its path).

[weezle11]

How do you embed a word file and link the file to a place stored on a server?

[ceprogram]

Actually, I don't know how to use AppleScript. But if I can get it... how would I sent a text field to the full path of my Excel file? If you could give me an example, I would then "plug in" my path. I also have a PC and can do it on the PC if it's easier. ; )