Hi,

I'm working on a database for the lab that I work in. Because reagents and procedures change frequently I have set up the database using 4 files. Each houses various information that contributes to the overall record.

My question is scripting between files. I have a button that is scripted to open another file. Once open I need it to go to a certain layout in the new file.

I can get the 2nd file to open without difficulty. But I can't get it to go to the certain layout I want.

My current code is:

Go To Layout[]

I chose "Layout Name By Calculation"

in the calculation field I put:

"PrimerSub"

Is I just put PrimerSub without the quotes I get an error message "Specified table cannot be found"

But this script isn't working if I have the quotes. It is just going to the original layout in the newly opened file.

I hope this makes sense. If anyone has any ideas that would help me out greatly.

Thanks

js22

In the calculation area enter the number of the layout, e.g. 42. You will find the number when you are in layout mode in a box directly under "Layout:"

Remember if you delete a layout or change the layout order the number changes as well, but not in the calculation.

Oh, btw, these tables are related, are they not?

If so you should be able to go directly to them.

Edited October 27, 200619 yr by Guest

It sounds like the piece you are missing is the Perform Script script step. You actually want two scripts. The first script should be in the first file and contain all the steps you want to do before changing to the layout plus the Perform Script script step. The script will perform the Go to Layout script in the second file.

BTW, the second file will change layouts but won't activate unless you use the Select Window [Current Window] script step in the second script.