>Dave;
>
>Thanks for the reply.
>
>>make the SP call the 'default' value for the field.
>
>My problem isn't what to do in a stored procedure. I don't see a way to call a stored procedure through ADO from Visual Interdev. Do you know of a way?
>
>
>Jim

If you put your NewID stored procedure in the .DBC, and set the default value of your Primary Keys to NewID() then even if you add a record with ADO via ODBC the stored procedure should run an produce a Key for you.

BOb