I have a content type for products. This has a (dropdown) field with values for each product. They choose a product and then enter the price for it.
If I want a view showing products that have been entered and their prices it works fine.
However, I want the view to show all products and their prices (if they have been entered).
e.g. I have available products: foo, bar, baz. There is a node for foo with a price of $10. No nodes for bar and baz yet.
My view shows: foo, $10.
What I want is for it to show
foo, $10 bar baz
There isn't, by default, a relationship I can add (e.g. Content: Products).
What's my best bet?