I've never used this feature, but I think it may do what I need.
Say I have a column for exterior car color (red, white, blue) and a second column for interior color (black, gray, white).
I want to create a drop down with some constraints - if i choose red for exterior car color in column 1, i cannot choose white for interior color - only black or gray will be permitted.
I'm going to have 88 columns and each column will have between 2 and 10 different choices. Each column will be dependant on something else - so this is going to get really complicated. . .any suggestions???
Thanks,
Say I have a column for exterior car color (red, white, blue) and a second column for interior color (black, gray, white).
I want to create a drop down with some constraints - if i choose red for exterior car color in column 1, i cannot choose white for interior color - only black or gray will be permitted.
I'm going to have 88 columns and each column will have between 2 and 10 different choices. Each column will be dependant on something else - so this is going to get really complicated. . .any suggestions???
Thanks,