AnsweredAssumed Answered

Looking for an efficient way to manage numerous relevancy choices

Question asked by rowright on Sep 9, 2016
Latest reply on Sep 12, 2016 by Carmelce

I know you can control answer choices via the relevant field, but I'm looking for an efficient way to do this for 149 relevancies. First a very brief primer on the project and issue. At deer check stations we will be documenting where individual deer were harvested down to the square mile, which is described as a combination of the Township, Range and Section values e.g., T12 R16 Section 14. Each combination of Township and Range (orange squares in graphic below) contains 36 Sections. The problem is that those along the Mississippi River are incomplete and it really messes up data post-processing when someone enters a Section number that doesn't exist. (For various reasons identifying the harvest location on a digital map is not practical and it is done via a wall map. I would like to control the list of Section values available based on the T/R combo that is entered e.g., if T12 R16 only has Sections 1, 2, 3, 4, 7, 8, 9 and 14 associated with it, that's all I want the user to be able to select from. The efficiency challenge is that there 148 T/R combinations and 49 of them have less than a full complement of Sections. Suggestions? Feel free to contact me at Robert.wright@state.mn.us. Thanks for any help.

Outcomes