Dynamicly Building Drop Downs / Filters

[Snowboyd]

Hi there

I have a problem that I can't figure out

I have a largeish list of products in a table with initial rows for Category, Agreement Type, Product and Product Ref. In the following rows there is information specific to the product on that agreement type such as Target Price, Contract Length and Minimum Price

I want to be able to build orders of multiple products on sepearate rows on a form so:

On the first line I drop down the Category and Service Type which will massively reduce the list in the drop down for Product.

Once I select the Product then Product Ref, Target Price, Contract Length and Minimum Price are to be returned in the following rows.

So data looks like this

Product Category Name <tbody> </tbody><colgroup><col></colgroup>	Agreement Type Name <tbody> </tbody><colgroup><col></colgroup>	Product Name <tbody> </tbody><colgroup><col></colgroup>	Product Ref <tbody> </tbody><colgroup><col></colgroup>	Target Price <tbody> </tbody><colgroup><col></colgroup>	Contract Length <tbody> </tbody><colgroup><col></colgroup>	Minimum Price <tbody> </tbody><colgroup><col></colgroup>
Hatchback <tbody> </tbody><colgroup><col></colgroup>	Sale <tbody> </tbody><colgroup><col></colgroup>	Focus <tbody> </tbody><colgroup><col></colgroup>	100001 <tbody> </tbody><colgroup><col></colgroup>	14000 <tbody> </tbody><colgroup><col></colgroup>	0 <tbody> </tbody><colgroup><col></colgroup>	11000 <tbody> </tbody><colgroup><col></colgroup>
Hatchback <tbody> </tbody><colgroup><col></colgroup>	Rental <tbody> </tbody><colgroup><col></colgroup>	Focus <tbody> </tbody><colgroup><col></colgroup>	100001 <tbody> </tbody><colgroup><col></colgroup>	2000 <tbody> </tbody><colgroup><col></colgroup>	3 <tbody> </tbody><colgroup><col></colgroup>	1500 <tbody> </tbody><colgroup><col></colgroup>
Hatchback <tbody> </tbody><colgroup><col></colgroup>	Service <tbody> </tbody><colgroup><col></colgroup>	Focus <tbody> </tbody><colgroup><col></colgroup>	100001 <tbody> </tbody><colgroup><col></colgroup>	3500 <tbody> </tbody><colgroup><col></colgroup>	3 <tbody> </tbody><colgroup><col></colgroup>	2000 <tbody> </tbody><colgroup><col></colgroup>
City <tbody> </tbody><colgroup><col></colgroup>	Rental <tbody> </tbody><colgroup><col></colgroup>	Corsa <tbody> </tbody><colgroup><col></colgroup>	100003 <tbody> </tbody><colgroup><col></colgroup>	1500 <tbody> </tbody><colgroup><col></colgroup>	5 <tbody> </tbody><colgroup><col></colgroup>	1000 <tbody> </tbody><colgroup><col></colgroup>
City <tbody> </tbody><colgroup><col></colgroup>	Service <tbody> </tbody><colgroup><col></colgroup>	Corsa <tbody> </tbody><colgroup><col></colgroup>	100003	2000 <tbody> </tbody><colgroup><col></colgroup>	5 <tbody> </tbody><colgroup><col></colgroup>	1500 <tbody> </tbody><colgroup><col></colgroup>
Hatchback <tbody> </tbody><colgroup><col></colgroup>	Sale <tbody> </tbody><colgroup><col></colgroup>	Astra <tbody> </tbody><colgroup><col></colgroup>	100008	13000 <tbody> </tbody><colgroup><col></colgroup>	0 <tbody> </tbody><colgroup><col></colgroup>	10000 <tbody> </tbody><colgroup><col></colgroup>
Hatchback <tbody> </tbody><colgroup><col></colgroup>	Service <tbody> </tbody><colgroup><col></colgroup>	Astra <tbody> </tbody><colgroup><col></colgroup>	100008	3500 <tbody> </tbody><colgroup><col></colgroup>	3 <tbody> </tbody><colgroup><col></colgroup>	1500 <tbody> </tbody><colgroup><col></colgroup>

<tbody>
</tbody>

(plus 400 odd rows!)

Thanks

 

[Snowboyd]

*Bump*

I'm still struggling with this - any ideas?

Thanks

 

[royUK]

Have you tried AutoFilter or AdvancedFilter?

 

[Snowboyd]

Hi
Thanks but filters won't do the job as I want to create several rows (so row on the order could be for a Focus with a certain spec, the next row may be for another Focus with a slightly different spec)