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/
