Drop Down List Filtering

[0123ren]

Hi all, not sure ive used the correct terminology in the thread field but ill explain my situation.

I have a vat of information that needs organised and much of this can be placed in repetitive fields, hence the drop down list.
I want to organise the information in a sort of family tree formation, so for example, 1 listing i need to organise would be a family name. Now say when the earth started there were four people and two families e.g. A and B, I would want the first column to display a drop down list featuring these two families, I would select family A, then the second level of organisation would be the offspring of these two families (A would give C and D, B would give E and F), so after selecting A the second column would recognise this decision and the drop down list would adjust itself by omitting families E and F as they are no longer possible outcomes for the second level of organising.

Does anyone have any idea to manage drop down lists so they recognise the inputs of other drop down lists, sort of embedded almost??

I hope I have explained this issue well enough, sorry if i have inadvertently repeated a previous problem.

Thanks again, any help would be greatly appreciated.

Martin

 

[timorrill]

Try reading through this site to see if it has any information which may be useful to you.

http://www.contextures.com/xlDataVal02.html

It shows you how to create data validation drop-downs that are dependent upon other drop-downs.

 

[0123ren]

Thats fantastic, thanks very much for a quick reply

0123ren