Jump to content
Sign in to follow this  

Copying data after find

Recommended Posts


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.


Share this post

Link to post
Share on other sites


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


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


Share this post

Link to post
Share on other sites

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.



Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.