Incorrect data show in my dropdowns

[Ash_Zim]

Hi All

I am at a loss, so I have created a google sheet and with drop down menus (data validation) and it works great on the google sheet, but when I take it into AppSheet it seems to loose / move the data. ie 

In the google sheet when I select one of the drop down menus under the product header I get all the products based on the client i have selected (which is exactly what we need) when I go to the AppSheet and select products it brings back the headers of the sheet 

Any ideas or am I asking to much from App Sheets