I was asked to do a new application where they would like to keep track of each change for each field. For example if the address changes for a customer they want to know when the change was made and what the old address was. And this could happen numerous times for each field. Does anyone have any resources that I could look at to find the best way of doing this?? I would like to know the best database structure. I have a few ideas but not sure what may work easiest. Any help would be great!!