At 04:15 AM 17/05/2011, Jacob Havkrog wrote:

>Hi - you are right, the generator AddressNo_ADDRESS_GEN is called twice, once because of the GeneratorLinks, and once by the trigger AddressNo_ADDRESS_TRIG.
>
>Now I'm wondering, is the alternative trigger below the right way to do it? Is this the way create a new record in a table and knowing the value of the automatically generator primary key?

You should *always* write your triggers for auto-generated keys that way. ALWAYS - regardless of whether you are using IBO or any other application interface.

Helen