Autonumbering should never be used in the context to have any real world meaning to the user. If you need a number that is to hold a meaning, you should develop your own numbering scheme.
----- Original Message ----- From: "Nicky Avery" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 5:12 PM Subject: Re: Edited autonumber > David Ebert wrote: > > >What is the effect on autonumbered columns if a value is manually edited? > > > > > > > David, > > The autonumbering depends on its own housekeeping to know the value of > the last number it assigned. If you allow renumbering to a lower number, > you may end up with gaps in the run (not necessarily an issue) and, if > someone renumbers the records incorrectly, mismatches. If the numbers > are higher, you can end up with a mess since the autonumbering will not > know a number is already used and will plough on regardless so you then > have plenty of opportunites for mismatches. If the numbers are higher > and you define the autonum column as unique, you will likely break your > app when the attempt to reissue the number is rejected. > > Nicky > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
