Invetory problems

[lifeofasportsman]

I have an Inventory problem. I have set up a very large table with 8
diiferent variables and what I am trying tto do is on four of them set
up a
look up table. The diffacult part is when i open the first I need it
to open
the second and onle show items assosiated with the first selection.
For
example:

make model color dr
ford taurus Blue 4dr
ford taurus Green 4dr
ford taurus Blue 2dr
ford taurus red 4dr
ford pinto red 2dr
ford mustang green 2dr
chevy camrero greenn 4dr
chevy tahoe blue 4dr
chevy citation red 2dr

look up
Make Model Color dr
Ford Taurus Blue 4dr
Chevy Pinto Red 2dr
Mustang Green


Where the first choice is Frod and returns The model choices of
Taurus, Pinto and Mustang. The Second choice would be Taurus the pop
up look up would return the color list of blue, green and red and so
on. My problem is should I use an if statement or is there something
else that can be used so I don't have to have a mass amount of if
statements

 

[Rick B]

Do a search. Asked and answered almost every day. Look for "cascading
combo".

 

[tfossum]

I think this article will give you a pretty good primer on what you want to do.

http://www.databasedev.co.uk/filter_combo_boxes.html

-T