I like Peter B's suggestion, but having used them in Interbase, I recall one shortfall was that you could not have a generator based on another item, for example perhaps a Responsibility Centre. That may have changed in 9I Oracle etc.. not sure... Kent Heatherington