We have a top level site that contains various lists of data. The information in these lists are exposed to subsites using site lookup columns. In our subsites we have various lists that use a few of these site lookup columns.
Each of the subsites has an XSLT Listview webpart on the homepage so that management will have a quick overview of the information.
The problem is that the values of the lookup columns is always blank in the webpart. The actual list displays the values perfectly and as expected.
Here is an example just for clarity purposes.
On the top site which is the first site in the collection, we have a custom list called "Available Employers". We maintain just the default Title field with the names of the Employers and have some further custom fields for telephone, email etc. We then created a site column (also in this top site), of type lookup, called "Employing Partner" which points to the Available Employers list with the Title field set to display.
In our subsite we have a custom list called Students which stores information about a Student. We added Employing Partner from the existing site columns. This works 100% in the New/Edit forms and also in the views associated with the list. It just doesn't work when adding the built in webpart for that list to a webpart page.
I know the webpart and the view used on the webpart are not the "same" view based on http://blogs.msdn.com/b/arindam/archive/2012/04/13/a-quick-look-at-list-views-and-list-view-web-parts.aspx
To me it seems like there is no relationship between the webpart and the top site like there is in the actual list.
Is there any way around this or will an alternative method need to be explored to display the information correctly on the home page?