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
