I asked the same question sometime ago and was pointed to the following
greate site.

http://www.contextures.com/tiptech.html



"mpenkala" wrote:

Hi all,

Is it possible to have a drop down list in Column "B" which differs
depending on what you choose from a drop down list in Column "A"??

Ex.

Column A is a drop down field. You can choose "Floor" or "Wing"
If "Floor" is chosen, the Column B (which is also drop down) gives the
option of chosing "1st floor, 2nd floor, 3rd, floor or All"

If "Wing" is chosed, the options would be "A, B, C or D"

Thanks for your help,
Matt