Did you checkout triggers in the SQL Server BOL? The topic CREATE TRIGGER has some samples at the bottom. Sample E. Use COLUMNS_UPDATED should get you going in the right direction.

-Mike

>Hi friends!
>
>How can I make an insert trigger that whenever a new record is inserted in Table "A" it automatically inserts another record in Table "X" with data from the record in table "A" and data from record in Table "B". Any help would be appreciated.
>
>Luis