This is not necessarily true. The auto number column can generate numbers that have a user-defined format. I have an application in which the computer generates sequential numbers that are assigned to work order numbers with format 02-00001 and so on, where the first 2 numbers represent the last 2 digit of the year and the last numbers are sequential (and unique) number assigned by the system. I have housekeeping software that allows the user to go back and forth between years by changing the format of the first 2 digits of the auto number. This is particularly handy at the beginning of a new year when users sometimes have to enter old work orders that have the previous year prefix, the system determines what the next sequential number should be and assigns it to the new record and then goes back to the next sequential number for the current year. This is an ideal application of the auto number feature.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MikeB Sent: Wednesday, July 10, 2002 7:15 PM To: [EMAIL PROTECTED] Subject: Re: Edited autonumber 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/ ================================================ 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/
