Send Event to launch external application file path issue
Hello, I'm new to FileMaker. I'm not quite sure on the terminology, but I'm going to refer to the rows as "Records".
I have a table called "Test". In Test, there is a column called, "Illustrator" of the type Container. Every Record of the Layout has an Illustrator file (.ai) in this column which I have manually specified. In the Layout, I've created a button with a script that I intend to launch the Illustrator file for that Record.
Here's the script for that button: Send Event ["aevt"; "odoc"; Test::Illustrator]
If the .ai files are in different folders, then only the one that I've most recently assigned will work. The others result in the following error: "The file "blah blah.ai" could not be found and is required to complete this operation."
If the .ai files are all in the same folder, then they all work. Are these file references supposed to work across multiple folders? Does anybody understand the origin of this problem?