Conditional Drop Down Lists

[colemanj4]

Hello,

I have a form with 2 drop downs. In the first drop down you choose a
product and the second you choose the process step.

Now as an example I have products A, B, C and D. Product A has steps
1, 2, 3, 4; B has 1, 3, 4; C has 2, 3, 4; and D has 1, 2, 4.

I have a products table and a step table, but no links between them as
of yet.

So, is there any way to set up the second drop down list to only show
the applicable steps depending on the selection made in the first drop
down?

Any help you could provide would be greatly appreciated.

Thank you,

[Ron2006]

1) table of steps to look sort of like this:

A 1
A 2
A 3
A 4
B 1
B 3
B 4
etc.
now research cascading combo box in the group. there are plenty of
examples.

Ron