I have built a series of databases that work together to make one complete solution. The application has 3 different contact rolodexes as well as tape database. I want to place a button in each db that when pressed will open up the specified db. I have tried several of the provided button actions and none seem to cover this. Anybody know how to accomplish this?

You need to create a script, then attach that script to the button.

The simplest script might simply call another script in the other database which goes to a particular layout.

... and finishes with the Refresh Window [bring to front] step.

Here is the script that I have written, it does everything I want it to do except actually bring the document to the front.

Open ["contact.fp5]

Go to Layout ["form"]

Show All Records

Refresh Window [bring to front]

It opens the contact file

Goes to the Form Layout

Showing All Records

But, it stays in the background rather than overtaking the current file.

Any ideas...

[ September 27, 2001: Message edited by: Ryan Crowell ]

The script must end in the target file. Therefore, create a script in the file contact.fp5 that takes you to the desired layout and, just to be sure, use "halt script" as the last step. Then, create a script in your original file that executes this script as an "External script".