Hi Experts, I'm new here and have spent hours looking through the existing threads for some guidance, so I apologize in advance if this is already out there.
I'm trying to build a multiple dependent drop down list, but the third dropdown is dependent on the first two.
For this example, there are two types for the first dropdown (car/truck), then the second dropdown is the subcategories of each. The third dropdown is the rate, but this is what screws me up, there's a week rate and a month.
So say the first dropdown you select 'Car', then the second, you select 'aa', how do I go about making the third dropdown 'Week/Month, with corresponding rates only of that specific model appearing in the fourth cell?
Is this possible, or perhaps an easier way to achieve this end?
I really hope I've explained this properly.
Thanks in advance!