Conditional Value list using Custom Values instead of Field Values
I have 3 fields
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)
Jewelry: Ring, Necklace, Bracelet
Leathers: Bags, Belts, Wallet