1 Reply Latest reply on May 28, 2015 3:45 PM by philmodjunk

    Conditional value list with duplicate values

    DavisSmith

      Title

      Conditional value list with duplicate values

      Post

      Let me preface this by saying I'm not sure if this is any different from a normal conditional value list, as I've only been trying to make a conditional value list this certain way.

      I have two lists, a Category list and a Subcategory list. My subcategory list is drawing from a field in a table where there is a name and type. My category list is drawing from another field in another table. The difference from a normal conditional value list is that I have the same list of names repeated, with a few being omitted depending on the type. ex. Item 1, Cat 1; Item 2, Cat 1; Item 3, Cat 1;; Item 1, Cat 2; Item 2, Cat 2. So I basically want to filter this list depending on the category selected.

      How should I set up my relationship and value lists?