>>Vfp 9 SP1
>Then you could use Integer AUTOINC instead of N(10).
>That way you will be sure that you always will have a unique ID. There are some difficulties to get that Id back but all could be done.
If you want to add children before you save the parent, you would not be able to do it with AutoInc field.
If it's not broken, fix it until it is.
My Blog