Hi all
Next question (does he ever stop)?
My data ranges over 200 years, and in that time locations have change Name, States and Countries. Most DB seems to use City, State, Country, but then again boundaries don’t move very often.
Again I see ways of storing this:
1) Use 1 Table and have To From dates and a link to the next name.
2) Use 2 tables (a Geo Table (Locations don’t move (much)) and a Political Table (Man named things do)).
The first one can return false data if the code doesn’t find the real bottom. The second one feels wrong somehow .
Comments??
Neil