>Using VFP8, I would think that at least ZAP should reset the Autoincrement column. did I miss anything? or autoincrement is forever.
>
>Mo
I think it should not be reset, because then, by re-using the numbers, you might have an invalid "link" with old child data, which, if the autoincrement column is not reset, would be orphaned (as it should).
To have more control over the auto-incremented numbers, you can create your own function, and invoke it from the field's Default Value. The field should be defined as type Integer. This was the method often used before the auto-incremented was available.
If you are interested, I will post my version of this function.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)