Conditional value list with duplicate values
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?