>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.
Victor,
I'm not sure about MSDN article, but as Craig pointed out, he has a perfect example of the Autoincrementing code on his site, which is 99,9% proof (I substract 0.1% for data damage). So, you can use this code without doubts.
If it's not broken, fix it until it is.
My Blog