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