At 01:20 AM 9/03/2004 +0000, you wrote:

>Helen, what am I doing different with the trigger from before? it
>still increments 2.

See below.

>if I remove generatorlinks
>IDLOC=GEN_LOCATIONS_IDLOC
>i get an error
>Field IDLOC must have a value

Well, you get that because IDLOC is a required field.

>what am I doing wrong?

Probably the old trigger is still in the metadata cache. You need to log
out of all connections to clear the old caches. (if you can do so, stop
and restart the sever). First login after the caches are cleared will
activate the new version of the trigger (if you committed it before, that
is! :-) )

Helen