By rcombes on

I want to be able to display a vocabulary term using the term id that is stored in another field of the node.

Specifically, I have a vocabulary of dog breed names called Dog. I have a content type called dog_information that stores the breed(s) of the dog in two fields, Breed1 and Breed2. Since I am fairly new at Drupal and had to create the dog_information form using the Form API, the fields Breed1 and Breed2 end up storing the term id of the selected breed(s) instead of associating the taxonomy terms with the node.

I am now making a View that displays the information of the dog but I need to display the breed as the term name and not the term id.

How to I get the View to display a field that contains the dog breed name taken from the Dog vocabulary based on the id number stored in the field Breed1 (or Breed2)?

Cheers
Roland Combes

⋅ Categories: Drupal 6.x

Comments

oddible’s picture

oddible commented

Try using a Relationship in Views. Relationship lets you access other columns from a related data type.

rcombes’s picture

rcombes commented

Looking at the Add relationships list, I can't see any that would work for this case.

The only taxonomy relationship is Taxonomy: Parent term and I can't see how that would relate a Content field to a Taxonomy term.

- Roland

Thomasr976’s picture

Thomasr976 commented

I am trying to do the same thing using Views and Panels. So take a look at http://drupal.org/node/575282. It may give you some insights since the what you get in a panel pane depends in the View. The panels demo that I referred to is at http://panels.demo.logrus.com/

Note I have not tried doing what Merlin advised but when i do I will let you see the set up of the views if u are interested. Let me know