copying a found set with a new reference number as a copy set.
I want to copy a found set of records that are grouped by a number/code so each one has this number/code at the top of the form.
I want to duplicate all these records but with a new number/code on them, so that I will then have two or more sets but each set will be different by their number/code.
The reason for this is that I have a set of data that can have different scenarios, so I want to create the first set of data and then have copies of this so that I can manipulate the data in each set, giving me the different scenarios. This will minimise the data input as I will only change the relevant bit of data on the record on the new sets all the other fields will stay the same.
Does this make sense?