2 Replies Latest reply on Mar 10, 2017 6:56 AM by philmodjunk

    Multiple Filtered Dropdowns

    craig157

      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