Alan,

>how you are going to manage the use of one generator over another

each time a record is inserted?

every user will have to login to the system.

At that time I (well, my application) will know the company he
belongs and the generator to use.

>Sounds very cumbersome (the trigger I mean) to me

I just see no other solution

>...but I'm sure you know what you're doing...

hope so :)

Thank you

Duilio