Cascading multiple combos in Microsoft Access
If you, for example, would want to select a specific house from a list of all houses in Scandinavia.
This would be nearly impossible if you don't break down the list in levels and then present only relevant choices for each level.
Here is an example of doing this thru cascading an (unlimited?) number of combo boxes.
For further info you should look in the example database (.mdb) together with an text file (.rtf), all contained in the downloadable zip file 23,4 KB (23 993 bytes).
This is done in Microsoft Access 2003 but I like to think it would work in 2000/2002 also.