Update Multiple Select Options-- did you get it to work?
Hi - I have a table to update, we have successfully gotten the WA data assist behavior to insert a record with form fields that allow for multiple options.
Using hand-coding, putting the (implode) function ahead of the fields we are adding the options to, we get a comma-separated value inside the field in the database.
I am now building the Update form. In reviewing your post on this subject, I see that you went back and forth a few times regarding hand-coding the pages to allow for this. To review:
1. In order to update a field that contains a value of a comma separated array, one must first extract (explode) that array into a form that we can work with, putting it back into our check boxes, drop down lists.. whatever. We then have the update form with the already-selected options, selected on our update form. We do not want all of our users to have to reselect all of their options from scratch.
2. After the thing has been extracted, with the existing values pre-selected, we make our changes and use the update record behavior.
3. Since the behavior cannot recognize the multiple-options, we must then re-hand-code the options for that update behavior, adding the implode feature back into it. The results of this is that multiple options are put into the database as a comma separated array.
4. In this example, I will not be referring to checkboxes, since I am using all text fields.