move user to new layout in remote table to view data
How do you move a user to new layout in remote table to view data using a script. User has view only privileges
If you have a table occurrence defined in your current table, you can create the layout in your current file and just use Go to layout.
If you must go to a layout in a different file (assuming that is what you mean by "remote table"), things are more complicated.
You can use Perform Script to perform a script in the other file to change layouts and use select window to bring the window for that file to the front, but the script will also need to find the expected records as well. You may be able to pass this info as a script parameter to the script performed in the other file.
In other cases, if you have a table occurrence of that table defined in your current file and linked in an workable relationship, you may be able to use Go to Related Records with "use layout in external table" specified in order to select the layout in the other file. This might work to pull up a particular found set of records on that layout without needing to pass data in the script parameter and perform a find.
Retrieving data ...