Linda, This would certainly be possible for a particular install, but there would be some internationalization issues we'd need to address: We could hardcode the system to look for an authorized value list "STATES", and then let the use populate that manually; if unpopulated, use free text. However, this puts the burden on the user to create a list of relevant states, and is hardcoding a connection. We could provide multiple SQL files with the states for each country, and let the user load those at install time, but that would a) require us to compile such a list and b) maintain it. There would be the additional issue of what do to for Koha installations that service multiple nations; I'd assume they would prefer to group by country, so there would need to be some kind of mechanism for that. I suppose we could work up a special interface for geographic information, where we could divide by country, state, region, county, township or whatever other local geographic delimiter is used. This would bump up the complexity enormously.... perhaps there is an open datasource we could draw from for this? Cheers, -Ian On Wed, Jun 29, 2011 at 10:18 AM, Linda Culberson <lculber@mdah.state.ms.us>wrote:

All, In Koha 3.4 the state is a separate field (Hooray!!) Is there a way to tie it to a an authorized value (I've done one for the states and territories of the United States) and would like it to be a drop down.

Thanks! -- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Fax: 601/576-6824

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

-- Ian Walls Lead Development Specialist ByWater Solutions ALA Booth 732 Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal