Hi Andrew and thanks for responding. I'll try to explain this from another angle that might make a little more sense:
Let's say we have 3 content types of the following (which all use their own template files):
- Products Page
- Application Page
- Organization Page
Now let's say that we want to include links to product pages on the organization pages if and only if each product page node-references an application page that is being node-referenced from an organization page (including links to product pages if the product pages are node-referencing the same application pages that the organization pages are node-referencing).
Does that help? The rationale behind all this mess is that a product can encompass multiple applications and we have organizations which have multiple products but from everything, we're just trying to avoid duplicating labor because we can do a simple node-reference field from the organization page for product pages, but this constitutes a manual entry. We want this to be programmatic (automatic) by somehow making the organization template file determine which application pages have been node-referenced and based on that finding, determine whether or not those application pages being node-referenced from organization pages == those being node-referenced from product pages. If they do, then this would mean that that the product page is a product belonging to the organization.
(I hope that clears it up a bit. If we have to, we can go with the node-reference field on the organization template, but again, we're just trying to make everything as automatic as possible.)