Home > Using FileMaker Pro > Adding and viewing data > Entering data in records > Copying and moving data in recordsWhen you copy all the records in the found set, records are separated by carriage returns.
Your script creates one record and pastes first record into that one record. Copy All Records would require some scripting to parse each record in a loop to achieve your goal.
Home > Reference > Script steps reference > Records script steps > Copy All Records/RequestsExamplesThis script finds and sorts a set of records, switches to the Data Entry layout, copies the contents of the found set to the Clipboard, switches layouts and tables, creates a new record, and pastes the contents of the Clipboard to the History field.Perform Find [Restore]
Sort Records [Restore; No dialog]
Go to Layout ["Data entry"]
Copy All Records/Requests
Go to Layout ["History table"]
Paste [Select; History table::History]
Often a closer look at one is trying to do with such a copy and paste reveals that no such copying is needed, that a relationship can be set up that links to the data instead of copying it. This is not always the case, but when it is, it makes for a much simpler process.
And while Copy All Records has its uses, it destroys any data the user may have copied to the clipboard. There are other methods for moving data from one table to another that leave the clipboard data intact.