We have an outdated system of tracking rezonings, variances, conditional uses, subdivisions, etc. I'd like to set up a database that can eventually be tied to GIS (that will have to come later). I've got plenty of experience using Access so I'm comfortable actually creating the database, but I'm not sure what I can use for a unique key to track the different applications. I'd like to get to a point where I can look up a piece of property and see all actions that have been done to it or are pending. My first thought was to use the parcel number as the unique ID, but if the parcels are divided (or combined) the tax parcel ID will change.
Any suggestions or experience on how this database can be designed? Thanks!