A couple of options - and no, I won't be using the Northwind example - I'll use an even more general example.
If Record Selectors are displayed, you could just copy and paste a record, then change the Order Number (or whatever you've called it)
If you need to do something a little more tricky, you could use the Clipboard in a more imaginative way.
Say for example, you have some hidden fields, or there's only certain fields you want copied:
Create a delimited string based on the fields you want to copy,
send it to the clipboard
Go to your new record
Retrieve it from the clipboard
Strip out your delimiters
Put them into the new values
To strip the delimiters out,
might be helpful
I am a loud man with a very large hat. This means I am in charge