I have an update form for updating volunteer information that is stored in the website_cont table. One of the fields is populated from another table. For example, I have a field that stores volunteer jobs. The field is vol_job. The values from this field originally come from the vol table. The update form displays the data that is currently in the vol_job field of the website_cont table.
I want to use a comma-separated menu to update this field. when I load the update form the current jobs are displayed but if I don't select a job or jobs in the comma separated field, all the data in the vol_job filed is deleted when I submit the update. Is there some way to do this?
The code is below. Any help is appreciated.