Two tier lookup

[Guest]

I need to create a double lookup if this makes sense. I need the ability to
select a particular criteria from one combo box (field) and it determines
what is displayed in the next combo box (field).

For example:
The first combo box would allow me to select a particular product line
Electronics
Games
Tools

If I select "Electronics" it only displays the items in the electronics
lookup table
(i.e. radio, watch, computer...)
If I select "Games" it would only display the games from the Games lookup
table. (i.e. Monopoly, cards, etc...)
If I select "Tools" only those items in the tools lookup table are displayed.
(i.e. Hammer, screwdriver, saw...)

I am not sure how to research (i.e. what question to ask?) this topic. If
anyone could point me in the right direction or provide the instructions I
would appreciate it.

Thank you in advance for your help

Dave

 

[Guest]

Search on "Cascading Combo boxes" to find what you need.