with is the concept of record id's, (identity columns, etc.) as they pertain to web-based applications, (ie we want the id value without having to refresh the web page, so identity columns will not work.)
>

I don't know what you mean by this. When a 'new' is submitted from the web page, the script/program sends an insert to the server, then queries for the identity, once it has that it returns whatever to the browser... there is no extra trip. You could also have SP's that do your inserts and return the identity value as an output parameter, so you wouldn't even need a second query from the middle tier to the server to get the id.

BOb