Using a Script to open another Filemaker Database for use

[kelturner]

I would like to use a script to open and view another filemaker database from the one I currently have open. I have been able to run external scripts, but I would like to actually view the selected database.

[proton]

quote:

---

Originally posted by kel:

I would like to use a script to open and view another filemaker database from the one I currently have open. I have been able to run external scripts, but I would like to actually view the selected database.

---

Kel:

Well there are a number of ways to do this. The most obvious way is using the Open File script step. You just include it and specify the file you want it to open. When you run the script it opens the file and you can view the database. However, there is a trick to this ease. If you run the open script and it opens the file, and then you go back to the original database and run it again, you get problems. Sometimes it opens the file twice, or causes the target database to behave erratically.

So what I do, I create a script in the target database (that I want to open) called "Switch to this". All this script does is change to a certain layout (you can also let it find all records or whatever). Then I create a script in the original database called Open File X (where X is the name of the target database), and all it does is execute the external script "Switch to this" in the target database file.

And that's it. You're done.