AnsweredAssumed Answered

Conditional Value list using Custom Values instead of Field Values

Question asked by ClayReed on Jul 26, 2013
Latest reply on Jul 26, 2013 by philmodjunk

Title

Conditional Value list using Custom Values instead of Field Values

Post

     I have 3 fields
     Gender
     Division
     Category

     Obviously a person would select Gender and based on the gender the "Division" values load and based on the Division the "Categories" values would load. All of these values will never change. I know I can create a conditional value list using additional tables and relationships but I would prefer to use "Custom Value Lists", one list for gender, one list for division and two lists for categories. Can this be done and how would you do it?

     Each Gender contains: Men, Women
     Each Division contains: "Jewelry" and "Leathers" (Both Men and women have both of these divisions)
     Categories:
     Jewelry: Ring, Necklace, Bracelet
     Leathers: Bags, Belts,  Wallet
      

Outcomes