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
Sorry, but I see no way to do that without a table, but only category seems to be a value list that would be filtered by a condition and is the only list that would need to be present in a table if you included Gender and division fields in that table so that you can filter accordingly by both gender and division.