Create Duplicate Record from Child Subtable

I have a subtable of child records on a parent form. I want to create a button that can be clicked from the subtable. When it's clicked, I want it to add a new child record, & copy over all of the values in each field of the child record the button was clicked on (there's actually one field I don't want to copy; I'm not sure if there's a way to actually "duplicate" a record, but if there is, I can't quite do that because of this 1 field I don't want copied, so I think adding a new record & populating the fields from the clicked on child record would be best), and then redirect back to the parent record the user was on (where the duplicate record will now display). So, this button would appear on every child record in the subtable. I can't just create a button that populates with hardcoded values, as the values will change depending on which record the button is clicked from. Any suggestions?

------------------------------
Harrison Smith
------------------------------