Duplicating Records
If you want to add a record that is similar to an existing record, instead of using the Add Record command, you might save time by duplicating the similar record and editing the duplicate.
The Duplicate Record command duplicates not only the field and attribute data of a selected record but also its sibling, parent, and child relationship links.
On most tables, duplicate records are added as the last record in the grid. On hierarchy tables, MDM adds the duplicate record as a sibling of and just after the original record. Pressing F5 refreshes the Records grid and moves the duplicate record into its proper sort order.
To add a duplicate of a record to the current table:
...
1. In the Records pane, select the single record you want to duplicate.
2. Right-click on the record and choose Duplicate from the context menu, or choose Records ® Duplicate Recordfrom the main menu.
3. MDM adds the duplicate record as the last record in the grid and places you into the Record Detail tab for editing.

You cannot duplicate object or Workflow table records.