I use a button on a browse to duplicate a record, and before saving the "cloned" record, I rename the unique id.
This works on a table with one unique key, for example:
file_id - primary key, unique, alpha-numeric
However, attempting to duplicate a record on a table with two unique keys, see...