Parent and child dropdown boxes within a list view

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.

Hi @Symbia Could you put all of the logic in the data source field? The datasource has access to i: