Thanks - we are stuck with SQL7 for awhile unfortunatly - I'll look at your link
>The best solution is to upgrade to SQL Server 2000. SQL Server 2000 has a new function SCOPE_IDENTITY() that corrects this issue.
>
>For SQL Server 7, this is the only thing that I've seen:
>
>
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9736>
>good luck.
>
>-Mike
Ken B. Matson
GCom2 Solutions