Also in a related thought. I know a trigger has to be tied to either an insert or update event. So I'm thinking for each table I will have to have two triggers (one for each event). Is this true or is there a way to only have one trigger per table. If it isn't clear, this is my first time working with triggers.
Thanks for any help in advance.