The VFP ODBC documentation says that default values are supported. I have used this on web sites to create pk values. I don't remember if I used default values or insert triggers.

Look in the DRVVFP.HLP file to see which functions are permitted.

-Dave

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