The data source is DBC. I have the routine to generate the PK in a stored procedure in the dbc itself so it is sure to find it.

Thanks...

Tommy

>>When I add a new record to may table via ado and odbc my "default" value is not entered into my primary key. If i just open it in vfp and append or insert a record it works just fine.
>>
>>Is there a way to make this happen via ADO?
>>
>>Thanks in advance...
>>Tommy
>
>Is the data source a DBF / DBC?
>
>You may have to requery the recordset to see any primary key values assigned at the backend.