Create a batch of records based on a value?

[Geoffy1]

Hello All!

I am stuck on this problem.

I have created a packaging/converting database where I want to create a batch or set of records that are unique but copied from the first record of the set but based on a value that tells the file how many to create.

I have included a screen capture of what I am trying to do.

The "Total Across Jumbo" is listed in the top row of the dashboard, this will create a batch or set of "4" unique records but copy all information with the exception of the serial number or "Parent Roll ID". So the second set of records would be 5 through 8 and then 9 through 12 and so on....

The trigger could be a button to start the batch copy but I haven't been able to successfully figure this out. Is this a difficult thing to do, can anyone shed some light? Thanks! GE

dashboard.tiff