Removing duplicate node titles when using relationships
| Project: | Views |
| Version: | 6.x-2.3 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
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