Hi Nancy,

>

trigger
>Record-level event code that runs after an insert, update, or delete.
Different actions can be attached to the different events. Triggers run
last, after rules, and do not run during buffered updates unless
TABLEUPDATE( ) is issued. They are most often used for cross-table
integrity.

Wow, your message was as wide as the Mississippi ( I should know, I could probably spit in it from my office, no lie). Yeah, thats all the help I could find anywhere.

They are record level? Does that mean it may get called 200000 times if I use BEGIN TRANSACTION, I imagine its called after END TRANSACTION then? Or after the TableUpdate in the transaction? I don't know a ton about transactions either.