Thanks for your reply Marcin.

I think that your solution won't solve my problem. As I know, BeforeInsert will be called when the
INSERT is called and not after the commit!

Thus if there is a problem with the INSERT or there is a rollback, a concurrent transaction
inserting a record at the same time could cause a gap in the numbering!

Any more ideas?

Thanks!

Zd