Hi I have a question regarding 3 deep dependent drop downs.
I have a pile of tools I need to sort of different types some have more or less detail
I have 3 columns, A B C
So Column A is Type, B is Sub Type, C is Material.
A-is a list of tools working fine, brings up options in column B
B-is a dependent list on A that specifies the sup type. Drill, Std, Metric, Letter, Number, etc
C-is for material its made out of.
No matter what I pick for B, the materials are all the same, but working with dependent drop downs seems to me I'd have to make a list for each option in B. (I.E. I have 4 options for col B, then 4 more 'tables' for C with the same options listed. This would be a lot of extra drop downs all with the same information, and since I have over 40 options for col A I could see this getting really messy really fast. Also C has to change because for some tooling I have completely different material options. So any better way to do this?
Thank you
I have a pile of tools I need to sort of different types some have more or less detail
I have 3 columns, A B C
So Column A is Type, B is Sub Type, C is Material.
A-is a list of tools working fine, brings up options in column B
B-is a dependent list on A that specifies the sup type. Drill, Std, Metric, Letter, Number, etc
C-is for material its made out of.
No matter what I pick for B, the materials are all the same, but working with dependent drop downs seems to me I'd have to make a list for each option in B. (I.E. I have 4 options for col B, then 4 more 'tables' for C with the same options listed. This would be a lot of extra drop downs all with the same information, and since I have over 40 options for col A I could see this getting really messy really fast. Also C has to change because for some tooling I have completely different material options. So any better way to do this?
Thank you