We are building quite a complex content type, and we want to use K2 to do it.
A few of the fields feature drop down boxes, or multi-selects. But (ideally) we want to populate these choices from existing Joomla table values, or at least use the K2 Values in other selects later on.
The features we want to have are:
A way to assign a MySql query to populate the options in any of the select type fields (dropdown, multiselect or radio)
A way to assign a value and a label for all select strings. So that it can say "Orange Drinks" to an editor but record the id of that field "16".