• Sounds like you need a history table.

    Check this out

    http://database-programmer.blogspot.com/2008/07/history-tables.html