5 Replies Latest reply: Sep 10, 2014 6:44 PM by Ian Tye RSS

    List box for a multiple option field

      I have a field that comes from multiple option data.  The multiple options have been combined into one field with the responses separated by spaces.  For example,
      1     Pain FirstAid Medicine

      2     FirstAid

      3     Pain Medicine

      4     Pain ReferGP


      I would like to create a list box with the four values Pain, FirstAid, Medicine, ReferGP and then by clicking on one of the options select all records with that particular value.  For example by selecting Pain, records 1,3 and 4 would be selected, by selecting Medicine records 1 and 3 would be selected.

      Does anyone know how I can do this?  I have played around with list boxes without much success.