Narrow down a selection with multiple categories on a portal
I am new to FM an I am having problems selecting items within a portal.
I have various fruit and vegetables listed in a products table that are being referenced in a portal.
In the portal I want a drop-down to be able to select whether the item is a fruit or vegetable, then next to it I want a drop-down to show all the sub-types of only the option just selected, then in the 3rd drop-down I want the final options of the products that match the previous criteria to be shown.
I only seem to be able to get the second drop-down to show only one option.
Thanks in advance for any help given