>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.