Community

Views & Relation Module - Displaying fields from the relation for multiple line items

I have a relationship between parts and sub parts. A part is made up of one or more sub-parts and there are different numbers of sub parts (eg Part: Widget is made up of 1 frame, 1 case, and 3 foos) and then those parts can have sub-parts of their own.

I have used the relation module to set up a directional relation between parts (parent) and parts (sub part).

I have then created a view that includes the relationship as a field and then the quantity from the relation itself using the natural language formatter.

BUT it only displays 1 quantity, not the quantity of each sub part required.

What it displays is this:

Widget - Sub Part - frame
Widget - Sub Part - case
Widget - Sub Part - foo
Quantity: 1

What it should display is:

Widget - Sub Part - frame - Quantity 1
Widget - Sub Part - case - Quantity 1
Widget - Sub Part - foo - Quantity 3

If anyone could help, I'd really appreciate it. I think Drupal is fantastic and both relation and views are amazing modules.

Thanks very much