AnsweredAssumed Answered

Multiple Filtered Dropdowns

Question asked by craig157 on Mar 10, 2017
Latest reply on Mar 10, 2017 by philmodjunk

Hi All

 

I am sure this question has been answered many a time but was unable to search for the correct answer.

 

Essentially I have two tables with the following catergories:

 

Table 1:

Category

Model Number

Model Description

Manual Part Number

 

Table 2:

Manual Part Number

Warranty Option Description

Warranty Option Part Number

 

Now there is around 50 - 60 different 'Warranty Options' and are specific per model.

I've set up a relationship between the two tables going by the Manual Part Number

 

What I am trying to do is make a filtered 'Add to Basket' which only shows certain results depending on the dropdown.

So if I selected 'Blue Car' it would only the 'Model Numbers' in the next dropdown that fit the catergory of Blue Car and etc

 

So example:

Category > Model Number > Model Description > Model Part Number > Warranty Option Description > Warranty Option Part Number

Blue Car > XXT3446AB > Blue Car that goes fast > BLUETURBO2 > 12 Month Wheel Replacement > 12MTHWHEELREP

 

My add to basket is in a pop over button which will then update the related Portal with the Part Numbers required.

Please note - there could be multiple 'Warranty Options' selected per Model.

 

If anyone can point me in the right direction it would be great!

 

Thanks

Outcomes