2 Replies Latest reply on Apr 21, 2017 7:48 AM by tcwaters

    Struggling with a Value List

    tcwaters

      I've been struggling with a value list and would like some feedback about solutions to this issue.

       

      I have a value list called "CourseOutcomeChoices.  It pulls related data, and it works, in that it shows the correct data, but the value list is wrongly ordered.

       

      The data looks like this (field is Outcome Name)

      PittPharmacy Outcome 1: Learner

      PittPharmacy Outcome 2: Patient Assessor

      PittPharmacy Outcome 3: Caregiver

      (there are 11 possible outcomes.

       

      In the Value List, if I have it show the name, it shows them in this order:

      PittPharmacy Outcome 1: Learner

      PittPharmacy Outcome 11: Life-long Learner and Innovator

      PittPharmacy Outcome 2: Patient Assessor

      PittPharmacy Outcome 3: Caregiver

       

      If I have it also show a second field (id), it now displays in the correct order, but it looks like this:

       

      PittPharmacy Outcome 1: Learner 1

      PittPharmacy Outcome 2: Patient Assessor 2

      PittPharmacy Outcome 3: Caregiver 3

      ...

      PittPharmacy Outcome 11: Life-long Learner and Innovator 11

       

      I can't find a way to show only the name, but have it sort them in the correct order (by id). If I choose "show only second field" I lose the ability to sort by the first field.

       

      THX