Page 1 of 1

Custom field dependant on previous selection

Posted: 21 Aug 2009, 15:10
by mzenns
We need to know which of our locations the bug is being reported from, and we'd like to make it somewhat standard so we can report on it. Seems like no problem, as we originally created an enumeration custom field, making it required on report and required on update. The problem is that now we have 36 locations in 7 states, and that exceeds the per column storage capacity (65,000+ bytes) of the MySQL version we're using.

Therefore, is it possible to create a custom field with a state list, then have a second field created that would only show the locations in that state? If so, how would I create that?
:?:

Ubuntu 8.04 server
Mantis 1.0.8
MySQL 5.0.51a