cascading drop down menus

[Robert Leatherman]

Hi,
I was just wondering how to go about creating a drop down menu item that has
several levels to it. I'm doing a database of actors and actresses for a
local entertainment agency in San Antono. So say I wanted the first level to
be the gender, then color of skin, then, eye color, then height, then weight
etc.
Here is an example. I believe you have to use nested queries but how do you
set it up? Thanks.
gender
_
|male
|female -
|light
|dark -
|Blue
|Green
|Brown
|Hazel -
|Tall
|Medium
|Short -
|Thin
|Medium
|Large
|Extra Large

 

[James Goodman]

I wrote a sample DB which demonstrates this. It can be seen here:
http://www.angelfire.com/sports/f1pictures/AccQuestion2.htm

 

[Robert Leatherman]

James,
Not really what I wanted. I think that they have to be nested queries that call each other, triggered by an action on the form in visual basic. The company I used to work for developed a parts tracking system for the E3 AWACS. It used a menu first to select the form and then used expanding drop downs similar to a java interface on the web. I believe that they had to use a plugin for this when they developed it in office 97. I was just wondering if microsoft finally developed something built in that does the same thing. Don't sweat over it, not that big a deal really. It's just something I never figured out and would like to.
Cheers,
Bob Leatherman
SATX
I wrote a sample DB which demonstrates this. It can be seen here:
http://www.angelfire.com/sports/f1pictures/AccQuestion2.htm