Best way to handle problem

[bluegirl]

I am working a temporary job and trying to create an EASY to use for
for tracking training employees.

I have a LARGE list of classes. I have looked at handling this severa
ways: 1) Straightforward drop down list of all classes - Problem: Th
list is very large and the names are so long (with several variants o
each class - ie: internet class, classroom, or self paced training) an
the drop down box (which doesn't word wrap that i have seen) would hav
to be a full sheet wide just to see the entire course name. 2) A Use
Form which would accomodate a box that would be more adjustable to fi
the size of the list. Problem: I don't understand how to make thi
work and even after having READ the book, the help sheet, and variou
internet sites, still can't quite make it work.

What I would ultimately like to be able to do is this:

If the Track is Telephony: I would like it to drop down a choice o
TEST or CLASS. If Test is chosen, it would go to a list of all th
tests under that track. If Class is chosen, it would go to a list o
all the classes under that track. I could conceivable drop the TYPE o
class and leave it to another field.

There are about 15 different tracks with many choices under each. Thi
seems to be more manageable to the end user who is entering the data
but more of a headache for me to create. However, I like to do my bes
at anything even if it means getting in way over my head.

If there is ANYONE out there that has any ideas on how to make thi
work , I would GREATLY appreciate a little guidance.

Thank you

 

[JE McGimpsey]

take a look at Debra Dalgleish's page on dependent validation lists:

http://contextures.com/xlDataVal02.html

 

[Otto Moehrbach]

With as many lists as you appear to have and the dependency relationship
that the lists have with each other, the best solution is VBA
(programming). VBA will allow an unlimited number of lists and list
dependencies. Post back if you want to pursue the VBA route. HTH Otto