Thank you JulianKirkness. I ended up figuring it out on my own using a Macro (not a datamacro). For anyone curious, I'll post my code below. All I did was use the ID to set a variable for each value I wanted to copy, created a new record, and set the individual fields to the variables I had set...