>>Why not just assign the ID number _only_ when a 'Save' is done? Then you won't have to worry about keeping track of unused numbers.
>>Paul M.

>why not assign when added (can use internal function call for that) and forget the fact that the users may not save all new records? loss of numbers won't hurt the integrity (unless used for invoice, etc. but that shouldn't be done this way)

Numbers shouldn't be lost if they are only assigned to saved records...

Paul M.