1 Reply Latest reply on Jul 26, 2013 8:46 AM by philmodjunk

    Conditional Value list using Custom Values instead of Field Values

    ClayReed

      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