I've got two content types - Company and Product.

Product has a node reference field to Company so it can be associated with its manufacturer. Products are also tagged.

What I'm trying to is show a list of related Company node titles in a block when viewing a particular tag page. Through finally understanding what Relationships do, I've managed to produce a list of Company node titles related to a tag. The problem happens when a company has more than one product using the same tag (very common) and since under the hood, this essentially a list of products, I get duplicates in the company node title list like this:

Company 32
Company 32
Company 93
Company 93
Company 93
Company 129

When I want to see:

Company 32
Company 93
Company 129

I've tried checking every "remove duplicates" checkbox I can find but can't see how to get around this. Any thoughts?

many thanks

Martin

Comments

esmerel’s picture

esmerel commented
Status: Active » Closed (duplicate)

This may be related to the core 'distinct' issue; there's lots of other related issues. See http://drupal.org/node/579892 for instance.

If this is not the problem, please reopen the issue. Given the issue's age, I'm guessing though that it's no longer relevant or has been figured out.