I have a custom list (List ONE) with fields:
A, B, C
- A is simply a single row of text.
- B is a lookup field to another list (List TWO).
- C is a a custom field I've written.
How can I have the list view of my custom field, C, emit some values from a third list (List THREE) based on the value of the lookup field B?
In View and Edit forms, I plan to do this with Server-side object model in my FieldControl class (which is aware of the current context and the location of the current item in the list).
However -- in the List View, in XSL all it seems I can do is pull values from adjacent fields in the current list item (so I can get at field B) but I cannot then use the value of B to pull some additional data from List THREE. It does appear that XSL pulls the value from the overridden Field class (not the FieldControl) -- however in that class I am unable to get the current item in the list (it is null). i.e. the FieldControl class is aware of the current item in the list, but the Field class is not.
Any guidance would be greatly appreciated. Thanks.