Nice post, Eric!

>
>The answer is to make the primary key assigning part of the stored procedures of the database. SQL Server does with a datatype called IDENTITY, which is an automatically auto-incremented integer field.
>

And if you're backend store is Oracle, look at Sequences.....which are maintained in Oracle system tables and assigned via (if I recall) assignment of a column to a domain.

And if you're in SQL7, there is a new datatype called "uniqueidentifier" which will assign GUIDs....

My .02 to an already well-thought out post :)