Hello, Walter

100% agree. I was more radical than that - I gave up using integers as PK's at all. GUID was my way, generated by the client. It's a CHAR(36). So what? :)

>This is exactly the reason why I won't use the autoincrement feature. Handling new parent records and child records at the same time is virtually impossible in most cases. Therefore it is far better to use the old PK generator again, because you then know at forehand which PK you'd have to use.
>
>Walter,