Originally posted by criki
place a trigger on tbldata for update, delete and write your insert statement into tblHistory.
What I am having an issue with is, how do I reference whatever row is being deleted? In other words, what is the syntax for the INSERT statement. Is it just INSERT * INTO tblHistory? or something close?