AnsweredAssumed Answered

Conditional value list with duplicate values

Question asked by DavisSmith on May 28, 2015
Latest reply on May 28, 2015 by philmodjunk

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?

Outcomes