open a document with a different application

[Matthew F]

I'm trying to use the filemaker script step called "send apple event" to open a varity of documents using another application. The application is called GCK and I would like to specify which GCK document is opened according to the value of a field in my FileMaker database called "FileID".

With ScriptMaker's "send apple event" command I have specified the target application as "GCK", and sent the "open document" event with "Field value..." and I specified the field in my database called FileID.

The GCK application launches but does not open the files I indicate. Does anyone know how to accomplish this kind of task?

[keshalyi]

Well, I've never really liked the send apple event step (except for to open applescripts saved as applications, which works charmingly), but another way to do it might be this:

Make a calculation field that is an applescript whose purpose is to open the file. Then just insert in the calculation the field that contains your filepath. Make sense?

[BobWeaver]

Try sending the open document event to the finder instead of GCK. That often works better.