OK, so let's say I have a node for an item for sale, and each item node has an entity relationship to the stores which carry it.
So I want to create a view of items for sale, that has an attached view of the stores that carry the items in the view. My problem is that the stores are duplicated, even if I specify "distinct" in the query settings. It seems the "distinct" is applying to the items, not to the entity reference.
Is there a way to do this that I don't know about? Or is this possibly a bug?
Thanks for your help.