Clay Shannon wrote:

> We want sequential "admission numbers" in our app to be auto-generated for
> the user (they need to see them, but getting the next sequential value
> automatically rather than relying on the data entry people to always
> accurately know what the next one should be).
> A generator won't work, I don't think, because we don't want any missing
> values. IOW, if the user starts a record, and gets number 123445 and then
> for some reason doesn't complete the record, that number will be unused and
> there will be a hole in the sequencing.

Some company policy maker needs to be educated. Or promoted sideways.


--
Aage J.