> p.s. I know I could also get the gen ID and include it in the INSERT
> statement. This has a different problem in that I chew through a
> lot of ID numbers when proposed inserts are cancelled or aborted

But even if you use a trigger, the ID numbers will be lost if you
rollback. If you want a contiguous series of ID's then you will have
to implement a more convoluted method. See 'An auditable series of
numbers' on this page: http://www.ibobjects.com/TechInfo.html

In IBO (TIB_Query), I just fill in the Generator Links field and let
it deal with obtaining the ID.