hello again
I did as you suggested. The nextid in ids.dbf for table3 are now nicely replaced. So this part seems to work now. However, I still get the datatype mismatch error. So table3 doesn't receive the nextid. the question marks are comming out of my ears, so to speek. Maybe your newid() is the solutions, i so very much hope so.