That was my reference to the newid() function, used in the way you describe.

Neil

>Thanks for your reply, now I know where to put the code.
>I noticed in your code snippet, you are setting the key the hard way. I use a stored procedure as the default value for my primary keys

>then in the key field's default value I put new_key("sometbl","keyfield")
>and I never worry about unique keys