Woody,

>As long as you use the combination of the company number and the

generated number, then you can use one common generator

No, I can't. This solution was clearly discarded for other reasons.

>one solution I have used

I used that solution extensively with dBase/FoxPro.

I was young, then :)

But at the time I had the ability to open the table exclusively, pick
the number I wanted, increase it, store it again and close the table
for the next user.

>using some type of locking algorithm

I would like to hear more about it. How do you do it in Firebird ?
How do you conciliate its working in a transactional environment ?
Are you sure you took into account all the insidious subtle details ?

Frankly, this solution stinks.

Thank you

Duilio