Can you show us a screenshot of your domain model?
Here is a simplified version, with a few extra elements.
Storage is Location.
I was able to get it to work by making sure the list was in the correct data view, however in doing so I lost access to the Manufacturer and Product Series. To work around this, I denormalized the database.
I keep thinking there should be an easier way.