Cascading List Box dependent on multiple choices

[Jono]

Is it possible to have a list box who's list is dependent on selections made
in 3 other list boxes? I've used the instructions for creating a Cascading
List Box but this uses only one list box selection.

 

[Si]

Hi Jono,

Can you give a little more information on what you are trying to acheve
and what the selection criteria is based on for the filtered list?

Cheers,

Si.

 

[Greg Collins [InfoPath MVP]]

Yes, you would just follow the same techniques, but add additional filtering to handle the other two values.

 

[Jono]

Hi Si,

OK. This form is for the configuration of a machine. There are 5 types of
machines, let's call them machines A through E. Each machine has a storage
unit that holds tools. There are 3 types of storage units, let's call them X,
Y, and Z. And there are 12 types of tools, let's call them 1 through 12.
Depending on the machine the storage unit and the type of tools used the
number of tools held will be different. In some cases there is a choice of
how many tools the storage unit will hold for a given machine type/tool type.

An example:
Machine A can hold 3 tools of tool type 1 in storage unit X, but can hold
either 5 or 10 tools of tool type 1 in storage unit Z.

Machine B can hold 7 tools of tool type 1 in storage unit X, but can hold
20 tools of tool type 4 in storage unit X.

etc., etc.,

So I need a drop down listbox that will display how many tools can be held
based on the machine type, magazine type and tool type.

I hope that clears it up a bit. If not, let me know.

Thanks again,
Jono