The question is this: When making a duplicate record that contains repeating fields, is there a way to NOT duplicate the data in a specific repeating fields, other than using the script "Clear, "Field1 -2" etc. This database uses several fields that have repeats of 75 cells and using the above script method would require me to some 33,750 specific references to repeating field cells.

Case: I want to duplicate the purchase order that has 2 repeating fields of 75

line items each. I want the "Item to purchase" repeating field duplicate exactly but I also want the "Price each" repeating field to be blank.

Any suggestions??

I can think of a few different approaches:

1. Duplicate the record, then go to a layout that has the rep. fields on it, then loop through each repeat and clear it.

2. Make a new record, then Insert From Last Record the data from the fields that you DO want.

3. Export the original record, then import it, selecting only the fields you want.