linking County with City?

Apr 24, 2011 at 2:38 AM
Edited Apr 24, 2011 at 2:56 AM

I'm not sure what the LSAD column stands for but when you query City and County they both have stateid but do NOT have a link to eachother.  I was hoping to link City to County. Is there a way to do so?

 

** Also just loaded zipcode and same problem! No way to link zip to city or zip to county or zip to state for that matter. :(  Am I missing something??

 

Thanks!  Great job otherwise!

Coordinator
Apr 26, 2011 at 12:50 PM

What do you mean by link? A foregin key? You're more than happy to create it manually. The idea was to give a very plain DB with data so you can use it with your own data and reference it however you like.

Aug 22, 2013 at 7:36 PM
There's no way to link the two tables together. So I will have to manually find the county for each city and then modify the tables?