Steve, just in case it helps, there is a searchable archive for the list at you can search, using "autonum" for example: http://www.mail-archive.com/[EMAIL PROTECTED]&q=autonum.
This little thread reminded me of it, as the discussion ranged from the somewhat conceptual/logical, i.e. what is the purpose of autonum, to the implementation-specific, such as those specific lines of code from MDRD/Marc. Since it seems that you are smokin' away fast from the starting line, I thought this might be an additional resource for your "voyage of discovery". HTH, Steve in Memphis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Thursday, November 20, 2008 10:23am 10:23 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Auto number reset Thanks all Will Let the gaps occur. Good advice Steve ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Thursday, November 20, 2008 11:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Auto number reset << I have a auto number in a column in a table but there are occasions where we start to add a row to the table and then we do not add the new row, but the auto number has already been sequenced in the table. >> Don't do it. Let Autonumber be autonumber, and just ensure unique IDs. If you need a separate unbroken sequence for auditing purposes, generate those numbers _after_ the record is created using code. You can do that in a trigger. Still use the autonumber field to link records in different tables, but let users search (and print) the second, unbroken sequence field. -- Larry
