Emanuele,

Another user on another machine could be adding reocrds at the same time and they would get duplicate numbers.

The way to insure that no duplicates get in is to use a NextId table and a function that gets the nextid. I am sure there are examples in the download area here.