I am attempting to build an estimating application.  Within this application I need to have a 4 level lookup filter.  For example, the user selects the material dropdown which filters the type lookup which in turn filters the description lookup which in turn filters the size lookup.

How I am attempting to achieve this:

1. The Material field is a dropdown list.
2. I have a form (L2 Descriptions) which stores both the Material information and the Type information.  I have a lookup field called Type which is related to the Type field in L2 Descriptions.  The lookup field is filtered by Material == input.Material.  This works, no problem.
3. I have another form (L3 Descriptions) which stores the Material, Type, and Description information.  I have a lookup field called Description which is related to the Description field in L3 Descriptions.  The lookup field is filtered by Material == input.Material && Type == input.type2.  On user input of the Type lookup I am fetching the string for Type from L2 Descriptions and assigning it to a form field type2.  This is where it fails.  The field type2 is populated with the correct string from the Type lookup but the Description lookup is empty.

Thanks,

Dave