Thanks, but same problem. However you mark the last number used is still dependent upon that record being updated (committed). Dallas
-----------------

Have a table with the sequence numbers. Have a function that looks up the last number used, increments it, and returns the incremented value. For security, lock the record while it is incremented.