I would like to be able to create a cusomized list that can be used to input data in various sites and then display that data in another single site. Somewhat like a help desk in that each sub group of users has their own site(s) and can input and monitor
data in the list. The people working the help desk would be able to see all of the data entered at all of the different sites, but people at the differnent sites can see only their data. Note Im using Help Desk as an example.
I thought perhaps a connection to a SQL table to store/filter all of the entries depending on the site accessing the data using some internal Sharepoint functions to determine the site entering the data etc. Just not sure. I think some people refer to this
as a roll-up but I think it's more involved than that.
View Complete Post