I'm working on a site that I've structured with two content types:

A "studio" page has an image (often a photo of the subject of the painting) and some information about the painting, print or series overall.

A "image" page has a single image that shows the print or painting at a particular stage. Some images are part of a series so there are multiple final prints that are available. Some images are just early snapshots of my painting or printing process and aren't available as a final image. So an "image" page has fields like an "available" checkbox.

Every "image" page is associated with exactly one "studio" page; a "studio" page may have many images associated with it.

I'm trying to figure out how to use views to create a "studio" page that pulls in the thumbnails and dates for each associated "image" page. I can create views one at a time just fine but I can't figure out how to tweak the "studio" view to use a subquery like this (show thumbnails for all "images" with the studio page field set to "nid 37")

It seems like there has to be a way to do this, right?

To simplify it with an analogy: I've got a "people" content type and a "family" content type and every person is part of exactly one family. So I want my "family" page to show all of the "people" associated with that "family"

Thoughts? Leads?

Thanks!

Comments

gbrands’s picture

You might want to look into CCK and creating a node reference field and perhaps the Node Relationships module:
http://drupal.org/project/noderelationships

This one might also be of some use:
http://drupal.org/project/reverse_node_reference

Hope that helps!