Jump to content

Clearing repeating fields


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

Recommended Posts

I know repeating fields are evil but part of my solution requires importing multiple line item records into a single record in another file with repeating fields. I can get the import to work by setting a global repeating field with the values from individual records then importing those fields into the other file. The problem is that after import I need to go back and clear all the repeats for the next import. Using set field for "" for every repeat of the global fields works but it seems there should be a better way. There should be a way to use loop but I can't seem to figure it out.

Any ideas would help.

Thanks,

Wayne

Link to comment
Share on other sites

  • Newbies

Duplicate your database without the repeating field (tempdb). Select the records you wish to clear in the main database. Create scripts to import the selected record(s) to the tempdb. Use matching names. Delete the records in your main database. Import the records in your temp database into your main database. Delete all records in your tempdb.

Sounds complicated; however, it is only a few lines of code and it sure beats the options.

By the way,don't use set field for "", rather, use clear(field).

Link to comment
Share on other sites

If the repeating fields are setup with tabs on, there are 2 techniques that John Mark Osborne came up with that might make thins a little easier. Do a search at "www.databasepros.com" for reapeating fields.

Link to comment
Share on other sites

This topic is 7766 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.