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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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