we're using java swing client/server and sql 2k....

i guess the reason i say do it on the client is that you can create the uniqueid and then reference it immediately before inserting a new row - just like what's-his-name says...