0 Replies Latest reply on Mar 23, 2008 10:51 AM by cgrray

    update using comma-separated menu

    cgrray
      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.