Use selection from a dropdown inside a SQL query for a 2nd dropdown

[BastianW]

Hi,

I have a dropdown box called "Vendor" and another called "products". I fetch the content for the dropdown box from a mySQL DB. But what I would do now is that if the Vendor "XYZ" is selected, the dropdown box "Products" will show only the products from the selected vendor.

Any idea if that could be build and how?

 

[cheesegrits]

What you need is a database join element (for Vendor) and a CDD (cascading dropdown) for the "Products".

The products list would have to include a "foreign key" pointing to the vendor, usually a join element.

On the CDD you would set up the "Watch" settings with "Watch Element" being "Vendor", and "Foreign key" being whatever element in your products list which has the vendor ID in it.

-- hugh

 

[BastianW]

Thanks for the quick answer. Over the weekend I tried to find the "CDD (cascading dropdown)" it took some time to find out its an additional plugin here: http://fabrikar.com/download/details/36/2374-element-cascadingdropdown-plug-in