For the western states, Dakota, Nebraska, Wyoming, Idaho, Colorado, Nevada, California, ...
Finishing an environmental database that counties use for Permits.
For the Township / Range list box, I need to limit the list to actual numbers for each state.
For example: one state might have 20 townships, another state might have 33
It would prevent errors.
Can someone run a discrete value query for each State's township / range?
We track all endangered species, mating season, sightings, kind of thing.
For example: a county can avoid granting a building or road building permit in an area where a rare bird was sighted during mating season. There are many variations on this.
We are just attempting to keep data entry within bounds of reality.
Thanks!
![OK](https://pics3.city-data.com/forum/images/smilies/oglvvd.gif)