> I have tried your code, it didn't work but it gave me the missing link I was looking for.
> Problem solved!
>
> Although I find the double “where field_1 = new.field_a” annoying the version beneath works fine:

When it's speed stop satisfy you, try this:

as
begin
select field_2, field_3 from table_1 where field_1 = new.field_a into
:new.field_b, :new.field_c
end

And trigger must be before insert or update table_2, of course.

SY, SD.