I need to retrieve the values from a view column and use the result as the list of choices in a list field. I often meet the 64 KB limit of @DbColumn or because of the list field (if I use another way, script or DLL, to retrieve all the data). What is the best way to do this?
A few ways to deal with this. If you actually have 64 KB worth of choices, I see a couple of ways to go.
- "Use View dialog for choices" -- but then you lose the ability to typeahead in the field.
- Split up the field into two fields, set up as category and subcategory. This is complicated to program so that illegal input is impossible, but users may find this more usable than an interface that asks them to choose among over 1,000 choices in a single list. Cognitive scientists tell us that most people can effectively deal with about 7 choices in a list.