I have a sharepoint list that has an Employee Column (Person or Group) and an AwardType (Lookup). The AwardType is currently set to display a title from the document library.
Right now I have a CAML query that returns are the rows in that sharepoint list that are referring to a given user. What I need to do is get the award image files based on the lookup field.
e.g. If the user Roger, Williams has the catalyst award I will get back a row that has ows_AwardType="6;#Catalyst" and ows_Employee="472;Williams, Rogers". The AwardType is referring to a title in the document library and there is a jpeg file that was uploaded into the document library that I need a link/reference too so I can use it as the src for an tag.