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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.