Copying data after find

[rservis]

Hi,

I have a a table (supplier Line Items) that show items from suppliers, a bit like a catalogue and i would like to select some, maybe even all of the items and be able to create a purchase order.

I can do a search and am able to find all the items I have selected (say 4 items out of 100), the next stage is to copy each item and paste into my purchase order line items table.

Would a loop script be the best way to go?

Does this make sense?? ha ha

Thanks as always in advance.

Roy

[The Big Bear]

rservis

You can do this with a loop script and the set field command.

Create a field that you can use to marked the fields you want to copy and your script wouls resemble this

Goto first record

loop

goto next record(exit after last)

if(select = "X")

set field (the field to be copy and to the selected field.)

end loop

Hope this helps

Lionel

[Søren Dyhr]

In my humble opinion isn't it really a looped matter, since the dealings with the either the scriptparameters or $variables, is a vaste of processing powers, when import beween tables in the same file is posible. I take it for granted that the table structure follows the established many2many associated with invoicing/ordering...

Further does this approach abide to my own rules, which strive to make any parameter or variable be narrow scoped in utilization as posible.

--sd

linegrapper.zip