>>That's good, but why the other method didn't work? What exactly was wrong?
>
>I guess the following should tell CA to automatically update the id in the VFP cursor
>

>?"1) Refresh IDENTITY field using [SELECT @@IDENTITY] command"
>oCA.InsertCmdRefreshFieldList="f_IDENTITY"
>oCA.InsertCmdRefreshCmd="SELECT @@IDENTITY"
>

>I did the following in the builder built class
>

>lAutoRefreshNewRecords= .T.
>lUseDefaultRefreshCmd= .F.
>cInsertCmdRefreshFieldList= acbalid
>

>_BuildDefaultRefreshCmd method as
>

>TEXT TO THIS.InsertCmdRefreshCmd TEXTMERGE NOSHOW PRETEXT 10
>	SELECT @@IDENTITY
>ENDTEXT
>

>but I still could not locate the mistake till now.
>Have you tried Mark E. McCasland's builder? then you may have solved the issue.

Check Thread #1100805 Message #1111814 I found a reference to it on another forum