Jump to content

Clearing Repeating Fields


KnightShift
 Share

This topic is 6587 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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??

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6587 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.