Thanks. I'm punting on 3d down. I moved the getnewid procedure before the insert, and doing all the updates in one swoop and so far it's working. i'm taking it field by field and running a couple through, double checking the table and adding a field to the insert command....so far so good...thanks everyone...