Set field is usually the better option over copy and paste. Most of the time you would have a relationship between two different tables that have the same id, and then you would not have to search for the record in the second table. The records would be linked based on the the id..
copy/paste doesn't specifically cause problems in multi-user systems. It causes problems for the current user whether they are the only user or one of many by replacing any data they copied to the clip board with data copied by the script--irritating and confusing the user.
Set variable [$Var ; Value: select; TABLE:: field]
enter find mode
Set Field [ TABLE:: field ; $Var ]
perform find [ ]
Note that the enter find mode and perform find mode brackets are empty. Any criteria that you need to specify can be specified with set field steps.
For more examples of scripted finds, see: Scripted Find Examples
when i do first script above it works - goes to wanted table and returns to original table
tried second script before i started thread - this script brings you to first record in original table?
sorry its not between tables - its in one table switching between layouts
Don't put the variable in quotes in your set field step. If you do that set field enters the name of the variable instead of the value of the variable.