I have a data structure that is simply column 1 is "Category" and column 2 is "Product.
I want to have is to that I have a dropdown "Category" and a second dropdown "Product" that populates based on the Category picked in the first dropdown.
The problem I'm having is that I can't get the query to pull the correct data, as if I use "i" within an SQL query it just pulls the value from the first drop down and not of the dropdown that is on the same row.