So: I am making a WP site for a company that makes aftermarket performance parts for cars. I have used the post mechanic in WP to add in these parts. Each part has its own page, and I have registered two custom taxonomies: one describes the kind of part that it is, the other describes the kind of vehicle that the part fits. Each part is compatible with several vehicles so each post has a few different terms in the 'compatiblecars' taxonomy but it will only have one term in the 'partstype' taxonomy.
To build the navigation for the site, I have a list of the compatible cars and for the menu (which I am using YUI module for, that's not the problem!) I need to call a list of the 'partstype' terms that the posts in each different 'compatiblecars' term have. So, for example, there are twenty parts that are compatible with a Beetle for example, when you click on Beetle I need a list of the five or six different parts types (like, Brake Upgrades for example) that are compatible with the Beetle, and when you click on the term, you go to a page that has all the Brakes Upgrades for Beetles on it.
My understanding is that the best way to do this is to do a query_posts that calls all the posts with the 'Beetle' term in the 'compatiblecars' taxonomy, use the loop to pull the terms from the 'partstype' taxonomy for each individual part, dump these into an array and then echo that, and have each term link to that part type: my php skills are woeful, I am literally just beginning so I can't even begin to approach this without at least a starting point.
If this isn't possible, let me know, at least I can stop banging my head on this brick wall! Thanks!