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