"save a copy as" will only copy the file it is called from as you have found.
The thing you want to do is
file-manipulation from filemaker pro.
To do that you need a plugin. There a several very good plugins: Troi-FilePlugin (www.troi.com) , PCFilemanipulator (www.productivecomputing.com) and 360ScriptMaster (www.360works.com) that can help you achieve that. There are more then just these 3 :-)
You could add a script into the secondary file, which you call from your primary file.
MainDB is open
Script in main file
Open File : 2ndFile Hidden
Perform Script : SaveCopy from 2ndFile
Script in 2nd file
Save Copy as : 3rdFile.fp7
In the second file, the script named SaveCopy would need to be added, this means you are then calling the save copy command from the correct file.
To enable you to call the script from the second file, it will need to exist as a data source in the first file, I beleive
Hope that makes sense
Hey that worked, thanks! And using a script parameter when calling the external script, it even names the
copied file with a user-input name, so that's great. For me, this is preferable to using a 3rd party plugin to
accomplish the task.
If you can do the job acceptably without installing a plug in, that's almost always the better option. I have nothing specific against using plug ins, but each time you install a plug in, you acquire possible additional update/upgrade issues to manage the next time Filemaker Inc. releases a new version of Filemaker Pro. (Is the plug in compatible with the new version? If not, will the plug in publisher be releasing an upgrade soon?... etc.)