Hello all,
I have a temporary file being created in an order processing system.
After the user agrees the data is correct the data needs to be written
to a permanent table. There are usually 100 or so records. what is the
best way to do this? the fields names are not the same either and the
new records also need to be updated with the price from the parts table.
temp file: item number description qty
permanent file: item description pcs price
The price comes from the parts table. When I link the parts and temp
tables and try to insert into the permanent table, I am using a loop and
it's taking FOREVER. any thoughts would be appreciated very m uch.
Thank you.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!