Yes, that is an option I want to explore, but I also want the capability to send INSERT statements directly and get the autoincrement value back. If that is not possible, then we will only have the stored procedure option.

>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