Duplicating records in a loop

[hooty]

I am trying to find a set of records that are identified by a Category record id#, duplicate them and then switch the id number on the duplicates to a new Category record #.

Of course when I try to script this it can create a new record, copy over info in the set variables but gets hung up on going back to the second record in the found set.

If you want to see my current script you can but I'm pretty sure it's monstrous. I still have a hard time thinking in loops and steps.

help?

[hooty]

http://fmforums.com/forum/showtopic.php?tid/193891/post/284318/hl/duplicate/fromsearch/1/#284318

just found this thread, after looking for too specific of answers.

[hooty]

http://fmforums.com/forum/showtopic.php?tid/193589

this is the winner...omit records - how come things are always so easy, I was making it hard!