Hello,<BR><BR>I am new to this and on my way to learning. I hope someone can help me with a trigger. I want to update status of one table when I insert a new threat in another. This is what I have come up with so far.<BR><BR>CREATE TRIGGER [trg_Update_Status] ON tForumThread<BR>FOR INSERT<BR>AS<BR>BEGIN<BR>UPDATE tJournalTopic (STATUS_ID)<BR>SELECT STATUS_ID<BR>FROM Inserted<BR><BR>Thanks,<BR>Linkan