Steve
Unless there is a very compelling reason to keep the numbers consecutive I wouldn't worry about the missing numbers but to answer your question here is simple way of doing it. SEL MAX(autonumberColumn) INTO vrows INDIC ivrows FROM tablename SET VAR vrows = (.vrows + 1) AUTONUM autonumberColumn IN tablename USI .vrows,1 NONUM Buddy From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Thursday, November 20, 2008 10:45 AM To: RBASE-L Mailing List Subject: [RBASE-L] - 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. Is there any way of resetting this. Steve
