I have two tables. One is Projects and the other is Providers. The Provider table is used to enter information into the Project table with the use of a dropdown box with the names of the providers, services, etc. The information in the Provider table changes from time to time for each provider in that table. What would be the best way to keep the changes to the provider from changing the past entries in the project table and only change the ones going forward. I am thinking I am going to have to re-enter all the information for that provider and mark the old provider information as inactive. Any advise would be much appreciated.