You can toggle between open files by going thru the "Window" menu and selecting the file (DB) you want, but can you make a button do this?? I've been trying to figure this out for a while and I'm stumped.

Sure, its easy. Just run a script in the file you want to goto. When you click on the Perform Script Step, the first option is External Script. Select it, supply the file name and then select the script to run.

The External script you are running will usually look something like:

Enter Browse Mode

Go to Layout (desired layout)

Set Zoom Level (100%)

Scroll Window (home)

Toggle Status Area (hide or show, as you desire)

The last three steps are to make sure the layout displays as the user expects it to (we call this window control).

-bd

A 'Refresh Window [bring to Front]' step is not a bad idea on the end of the script in the file you are accessing, and you might also want to consider a Toggle Window [Zoom/Restore or Maximize - your choice] preceding it.

On the end of the script in the current file which is calling the external script, you might also want to consider a Toggle Window [Minimize/Hide] step. This is particularly useful for avoiding rampant window clutter if you have a number of files and are not maximizing them all.

Finally, you should, of course, consider creating the same set of scripts in the other files in your solution, so that you can return the same way you went...