Hello,
I've seen many posts on this issue but none seem to have found a suitable solution.
I think this is a common scenario in building database-driven sites and should be addressed.
The goal is to be able to select multiple values to be stored as an array in one database field (exactly like the "list of values" from the lookup wizard) but using dynamic data. we CAN'T populate a list of values from a database table, only a drop down (which doesn't support multi-select). So the ideal situation would be to either have a lookup wizard LIST loaded from DB values or even better having multiple checkboxes appear according to entries in another table.
To take the pizza toppings as a simple example, you would have a DB table 'toppings' where you insert all available toppings, and a 'pizza' table where you could click multiple toppings in checkboxes. Now, to create a field manually for each topping to use as checkbox OR to use a manual 'list of values' that allow multiple selection AREN'T good solutions since the goal is to be able to DYNAMICALLY ADD new toppings to the DB in the future and they would appear in the pizza FORM.
Here's a thought, maybe the simple solution would be to edit the script where the LIST OF VALUES is generated. Instead of having the values harcoded, it can loop through a table...
Any thoughts would be appreciated.
Thanks
