So my buddy has a problem with his ASP page... He is trying to have a pulldown in a web form that lists state/city combinations... if you select the state/state item, then it will look at all the state/city combos for that state when you process the form... here is the problem... the table looks like crap. Keep in mind that he lives in CA and I am in WA, so this all had to be done over Instant Message and Email. I wrote up some help for him, and decided to post that here in my blog...
An example of Poorly Designed SQL Tables