>Just as a follow-up...if you want to wrap all this up in a stored procedure, there was a discussion about this a few months ago. Check out message #
930339 from Bonnie Berent.
>
>If all you want to do is run a subsequent query, then the scope_identity should work.
>
>Kevin
I do not think, it would work for VFP tables. I thought, it's SQL Server function.
If it's not broken, fix it until it is.
My Blog