Hi,

 

I know that this question has been answered several times in the forums, and I have tried using the script but I am obviously doing something wrong as it keeps throwing up errors. I must be making mistakes when changing the code to fit my form names and field names.

 

Please assume zero knowledge when replying to this - sorry!

 

I am trying to create drop down lists that filter to 4 or 5 levels.

 

I have a small business that has 2 different divisions: design and printing

 

within these divisions I offer hundreds of different products and I need a quick way of finding these on an enquiry form (eventually this will also be rue of a quotation form and an order form).

 

I have a lookup box that allows choosing Division A or Division B.

 

The next field is a lookup box for Product Type. I want that box to then only display the products offered by either Division A or Division B.

 

Similarly, there is a further lookup box for Product Sub Type. I would like this box to only show the products that are offered from the correct division and the correct product type.

 

This will need to then be continued for size, paper weight and finish.

 

For the example of the first 3 drop down boxes I am creating a form named 'Enquiries'.

 

I then have a filed named 'Division' which draws the data from a 'Division' form.

 

I have a 'Product Type' fiels which draws its data from a 'Product Type' form.

 

I have a 'Product Sub Type' field that draws its data from a 'Product Sub Type' form.

 

Like I said, I have seen the examples already listed, but I am making a mistake in replacing the form and field names, or I am pasting the data in the wrong place.

 

Can anybody help please?? :/