<< 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
