I have a online Webdev 12 form where I want to allow the user to select a 1 or more options from a Multi-Selection List Box and store those selections in a MySql Table.
For example:
Please Select 1 or more options from the list:
A
B
C
D
E
The problem is that only the 1st option selected is stored in the DB.
If the user selects A, D, and E...only A is stored in the DB.
I also want the user to have the ability to go back into the form to edit selections.
So if they intially selected A, D, and E...I would like A, D, and E to be highlighted when they go back into the form in Edit mode.
Is this possible?
As I'm writing this I'm wondering if I could use a Looper Control to display all the options with a check box next to it like so:
[ ] A
[ ] B
[ ] C
[ ] D
...The user could then check and uncheck the options they want, with the checked options being stored in the DB. When they re-enter the form the options they initially selected will be checked.
Am I making this to complicated?
Is there an easier way to do this that I'm not seeing?