AnsweredAssumed Answered

Dynamic Scripting

Question asked by Jason_Farnsworth on Nov 29, 2011
Latest reply on Nov 30, 2011 by beverly

Ok so I have not done any scripts that involve loops to keep looking repeating its self until it is out of records to look at.

 

What I need to do is

 

Look at my lineItems

Extract all of the process ID's and all material ID's linked to that lineitem

 

Then Goto the "PVA Table"

Get all the Vendor ID's that are linked to each Process ID and each MatID (Both are found in this table some lines have a Process ID some have Material ID but all lines have a Vendor ID)

 

Then Goto the "BIDREQ Table"

Create a new Record for each of the Vendors ID's, and with in that record set the fields of the information found, Vendor ID, MatID, ProcessID Etc.

 

 

I will trigger this script with a button

 

Thanks in Advance,

 

Jason

Midland, TX

Outcomes