I am looking for solution to issue I would think would be a common problem;
I need to relate to data cross site.
My structure is as follow:
One top site.
A list of department sites all created under the top site.
I need to be able to relate data from a list no matter if it is the top site or one of the other sites in the farm.
E.g. to make a dropdown selection on a task list that relate to another task list on another site.
Would you have a solution to this?
I want to do the same as if I use the “Lookup” function when adding a new column to a list.
But when doing so, you only choose the lists/libraries that is located on the site specific site. But I want to ad data from another site in the collection.