When you open a record, in the "More" drop down there is a selection for "Copy this record". The challenge we face is that there are 650 records that need to be duplicated (in the same table) and then some minor modifications would be made but 95% of the data in each record is the same.
This table has 132 fields and 7 table to table relationships with many lookups. We want to preserve all of those relationships when copying/duplicating.
The "Copy this record" does exactly what we want to do, but that solution doesn't scale to have someone open every record and manually copy.
I've search in numerous help forums but could not find a solution.