How insert current record into another table with button by script.
It depends on your SQL. If it is already built, the easiest way is, e.g.Execute(“INSERT INTO …”); // In server events
but from list with the button
You may try the Row_CustomAction server event (in which you can use Execute()), see the topic Server Events and Client Scripts in the help file.