>>>How exactly would I take it in VFP9? Also here we're currently using VFP8, should I tell my users to wait till we get VFP9?
>>
>>Certainly not, but I would check AfterInsert anyway (sorry if it's not there, I don't have VFP8 on this computer).
>
>There is AfterInsert method, but I still don't get how can I take the ID. Do you suggest to try Table.Field as opposed to Alias.Field assuming the table is on the right record?
>
>I was also thinking yesterday, may be I should specify AutoInc for the field in CA directly (in its schema property). However, I don't know the AutoInc implementation, so I do not know all the risk involved here...
Yes, it could be some risk, I guess. Btw, 'nextid' is a time-proven way, and it could be implemented seamlessly. Frankly, I still use it in VFP9.
Edward Pikman
Independent Consultant