Hey, Dan,
Completely off the top of my head...
If you're using the VFP9 OLE DB provider, doesn't that support stored procedures with return result sets? Your VFP stored proc could do the INSERT, call the function to get the value of the inserted key, and return that value as a "result set."
Again, just off the top of my head....let me know if that helps.
Kevin