I have a Orders file that relates to a LineItems file via OrderID.
How can I duplicate all the LineItems from one Order and assign them a
new OrderID? FM7 in a cross platform solution.
Thanks,
G

I answered my own question, and thought I'd share the solution. The
script goes something like this...("g" fields are globals)
Start with the record you want to dupe (ie with a portal)

Set gOrderID1 to OrderID
Duplicate record
Set gOrderID2 to OrderID
New Window
Go to LineItems
Enter Find
Set OrderID to gOrderID1
Perform Find
Loop
Duplicate Record
Set OrderID to gOrderID2
Omit Record
Go to Record First
Omit Record
Exit Loop if Get(FoundCount) = 0
End Loop
Close Window

In article <1132643737.283023.30700 (AT) g47g2000cwa (DOT) googlegroups.com>,
grip (AT) cybermesa (DOT) com says...
Looks good. There's a variety of ways you could have iterated through
the records to duplicate them, but there's nothing wrong with your
approach.

You'll also want to add some error checking... and make sure your loop
has a found set to work on after the find.

Other than that... Just be sure to comment it...

-cheers,
Dave

Thanks. How do I comment a script? What should I include in the
comments?


For the found set I can just slip in a

If(Get(FoundCount) = 0
Close Window
Show Custom "No LineItems to copy"
Exit Script
End If

In article <1133204052.792190.207690 (AT) g49g2000cwa (DOT) googlegroups.com>,
grip (AT) cybermesa (DOT) com says...
Add a "comment" script step. It does nothing but hold the text you put
into it.

Think about what someone else trying to figure out what the script does
5 years from now would want to know. Include that.