Triggers

[sujit kondapaneni]

Hi,
Our requirement is an Insert and Update Trigger.
We have a Transactional table -A and an Interface table-B

1)When a new record is created in A we want the PK of the row to be inserted into the Interface table B.We are using "After Insert" and it is working fine.

2)The Update trigger has 2 components to it.
--when ever an update happens then Column 123(not a PK)on the transaction table has to be updated with a value lets say "Test" and then the PK of the updated row should be inserted into the Interface table B..We are using "before update"

Issue:
when ever an insert is done in the Transactional Table-A the update trigger is also firing and updating the Column 123 with the value "Test".
How do we stop this.

Your help is appreciated.

Thanks