I'm new to drupal and coming from a heavy focus on relational databases. I'm struggling to do things that I would find easy in a traditional database.
Here's an example of the kind of thing I'd like to solve.
I have a content type called "product image"
I want to classify those images by vendor. I also have the vendor's address.
So I create another content type "vendor" and give it appropriate fields including state.
Then I create a node reference field in the product image type, referencing a vendor.
All seems well to this point.
But now I want to be able to create a view (views2, drupal 6.x) that shows the images along with the vendor's state. No dice. While I can see that state field when defining a view, it shows blank on the resulting view.
Ideally I'd like the user to pick the state and have the images come up that are classified with vendors in that state. No dice there either. It seems that the views module only knows how to show & filter the fields from the product image content type, not from the related vendor.
Any suggestions? This seems so basic to me, so I'd imagine drupal can do it, but I've googled in vain for even basic information to get me started. I'm wondering if I have to modify the SQL somehow a la http://drupal.org/node/409808
, but that seems to be much harder than I'd expect for such a simple thing.
Any push in the right direction would be helpful.