>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.