Subject Re: Need advice
Author jasajona
Something like this:

CREATE TRIGGER SETTBL2FLD2 FOR TABLE1
AFTER
INSERT
AS
BEGIN
INSERT INTO TABLE2 (FIELD2) VALUES (NEW.FIELD1+OLD.FIELD2);
END

How to do it right and fastest for execution?