On 8/18/06, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
> Unfortunately this gave multiple results on the target tables.
>
> Is there a format that will give me a single insert for each original field
> without the need of creating three triggers???
>
> Bob
try using old/new in your trigger functions.
insert into table (targetfield) new.field;
merlin