This is a follow up to this question.
I have created an announcements list (built in type). I want to be able to categories an announcement. i.e. Soccer, Football, Golf.
I also want to display an image depending on the category.
My initial thinking was to create a custom list; Announcement Category. Where the title was the category name. I would then a file column. I can't do this as file is not a column type. So instead I am adding a Hyperlink or Picture column. I can then reference an image.
When I add a Lookup (information already on this site) column. I have pointed this to Announcement Category. I can show the Title field of the list however I do not have the option to display the Hyperlink or Picture column.
I need the Hyperlink or Picture URL in the Announcement list as I am performing a custom xsl transformation on the xml to style it in a certain way.
I know I could put some logic in the XSL to display an image based on the title but it would not allow my end users to me able to change the Announcement Category image.
How can I best display an image for all particular types of an announcement?