Do you mean you want two copies of the same file on two different servers?
I want to create data in one file and be able to view it in different layouts in two other files. Basically create data and view it in dashboard or summary formats in two others. Works great with opening remote, but I only get one view and one mouse. If they were seperate files or on different machines that would give me the capablility to create it in one, and change views of it in others.
You can do this by using what we call the "separation model". You have two files. One has the data you want to see. The other will be the file from which you want to see it.
Start by creating the file with your data in it. Build all the goodies for entering data. Once that's done, build a completely separate file. On your Relationships Graph, create table occurrences (TOs) for the tables in the first file. They'll show up with their table names in italics (to indicate that they're externally referenced). You'll need to create an external data source for the first file, which you can do at the time you create the first TO:
Once you have the TOs for the tables you want from your data file, you can use them just like they were in the interface file. You can build layouts, reference them in calculations in scripting, whatever.
Another option would be to open a second window in your existing database. The separation model is normally used when you either want to control the interface for different groups of users, or when you have a solution where you don't want to have to migrate data as often as new releases come out. If there's no need really to have a second file, then you can just have another window that looks at the same file. Each window can navigate to its own layouts, found sets, and so forth. That might be all you need.