.

thank you

Understood, since it was a trigger post I thought it should have been in here originally. I noticed that and thought I would get more feedback in this forum. ...

Sorry I am really new to triggers. Now when in SQL Server Managment Studio and when attaching a trigger like this. What table would you attach the trigger too? You...

I cant post the DDL sorry, but this is the structure of the tables that I am look at.

Sales(table) has Column key3

Users(table) has Columns UserID,UserName

Department(table) has column Account

When someone...