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,