<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>

You might consider something like:
```
```
locations
  id int
  parentId int
  name varchar(45)
```
```
From this perspective you could load any type of location with any level depth.