Inserting calculated value after insert on a different table version 2

[philrm]

Hi there

I have Three tables T1, T2 and T3. The primary key in T1 links to T2 but T2 has a different primary key. T1 also links to T3 in the same manner. IE both are 1 to many relationships. When a new entry is made in T2 I need to check if there was data entered into a particular field (F1). If there is data then I need to use the value in F1 to calculate a new record for T3 and insert it. How can I do this????

 

[Rosko]

I would create an insert trigger for your case in which I would check the inserted.F1 field for the value you are looking for and do the necessary steps from within your trigger.

Gl
Rosko

 

[philrm]

Hi Rosko

Is it possible to provide me with this code. I am not that familiar with SQL. Thanks