Copying data from one Table to another

[adrian]

Ok

I'm trying to write a script that will do the following :-

i have a table for Quotes and a table for invoices, Both of these have Qty, cost, Details ... etc .... that repeat 10 times (so i have a 10 item quote or invoice)

What i want to do ,is make a quote.....The customer accepts the quote...then run a script that will move all required data from quote to invovice

I can get it to do one line, but thats where it stops!

attached a screen shot of said script so far....

Any takers!!

[-Queue-]

You have to specify each repetition to be set and which repetition to use in the current table to set it. This would be much easier using related Line Items' files. And Set Field is probably better to use than Copy/Paste steps.