Sivaraman,
go to http://www.ibobjects.com/TechInfo.html and download "An Auditable
Series of Numbers". It shows you how to enforce sequential numbers.

I am a bit puzzled by you using IB 6.0. Firebird 1.0 is basically a
bugfixed version of IB 6.0, whereas Borland has released newer versions of
Interbase. I am not saying that IB 6.0 is bad, but you can get better -
either for free (Firebird) or by paying for it (Interbase).

HTH,

Set

- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.FirebirdSQL.org/Foundation