When/How would you do this? When the user clicks a button, or when some event occurs?
In general, it's a bad idea to duplicate data like this, unless you're copying over a record to set "default" values - that is, you will "duplicate" the data, but you're going to update one or more fields after you duplicate.
Yes. Study my simple and fast code in this old question: Clone Record
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent