>>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...
If it's not broken, fix it until it is.
My Blog