Avatar

Level 2

I need some help with drop down lists.  I have 2 and require list #2 to populate according to the selection made in list #1.

DD List #1:

Dept 1

Dept 2

Dept 3

User chooses Dept 1, DD #2 will populate with:

Sub Dept toys

Sub Dept games

Sub Dept puzzles

User chooses Dept 2, DD #2 now populates with:

Sub Dept towels

Sub Dept sheets

Sub Dept napkins

User chooses Dept 3, DD #2 now populates with:

Sub Dept cookware

Sub Dept dishes

Sub Dept glassware

I know how to do binding in drop down lists, but that seems to only let you bind 1 to 1 (choose Dept 1 binds to Sub Dept toys).

Any guidance will be appreciated as our IT dept will not get to this for months and I'd hate to turn away an importatn client for something I  think I can do myself.

Cory