I've read many posts on this, but they all seem to be over-complicated and multi-faceted where the code becomes hard to follow for a newbie.
I have Suppliers and the Materials they supply.
dropdown1 is the Supplier and dropdown2 is the MaterialName. They are both pulled from a dataset called Materials where there is a Supplier field and a Material field. The dataset is populated with the relevant Materials that the corresponding Supplier supplies.
Once I select the Supplier from dropdown1, I would like dropdown2 to reflect only those Materials supplied by that Supplier.
I was hoping to do this as a filter without having to code, but hopefully the coding side isn't too intense.