3 Layer Relationships - Vba? Use Access Instead

hi trying to vreate a table for user to upload data. some fields have a relationship and can only select ceratin things from a list dependent on what the previous columns selection is.

Column A selects from defined list 'animal' -cat, dog, mouse

Then if they select "cat" columc c uses define list 'cats' = siamese, persion, mungrel

but if they select dog it will force use of defined list 'dogs' = poodle, labrador, mungrel...

but i then need to add a third layer to this!!!! THIS IS WHERE PROBLEMS BEGIN!

2 layer is fine for : http://www.contextures.com/xlDataVal02.html


but this will not work if for 3 layer..... example colum b, could be a dog or a cat, if mungrel is selected. if the 3rd column depends on both of these ie it matters what column a and b is before 3rd list is defined.....

plus im going to have about a hundred defined lists at this rate.. and ther will be other realtionships in the same table.... :S

i have the relaonships in the format of a list of possible combinations i.

A B C
cat siamese grey
cat siamese black
cat persian white
cat persian black
cat mungrelwhite
cat mungrel ginger
....

dog poodle black
dog poodle pink ....
dog mungrel white
dog mungrel black

There must be an easy way!!!! do i have to use Access?