Hi, I was wondering how to deal with data that changes, but the user still needs to access data from the past. For a database that deals with development permits for properties I have a primary key that combines tax roll number and Parcel ID. However, when a parcel is subdivided, the parcel is assigned a new roll number and parcel id. It would be useful for the user to be able to access the history of the parcel before the subdivision. How would you be able to tie the old data to the new data if the primary key changes? I can set up a table that links the old primary key to the new primary key, but how would this table be updated?
Thanks,
Michael Kohler
Thanks,
Michael Kohler