title: Database Schema design
body: <p>I am trying to design a location lookup in which the user can specify a location to any desired level of accuracy. eg. one of Country, State, City, Borough etc,</p>
  
  <p>I have a used a common location table, which will then be used in a lookup with the table name selected dynamically, but was wondering if there is a feasible alternative way to do this.</p>
  
  <p><a href="http://img386.imageshack.us/img386/3842/locationschemadh6.png" rel="nofollow noreferrer">alt text http://img386.imageshack.us/img386/3842/locationschemadh6.png</a></p>
  
  <p><strong>Edit</strong> The hierarchical table looks like the way to go. Thanks for the tip.</p>