Access Custom List in Parent site in sub-sites

Question

Access Custom List in Parent site in sub-sites

I have a parent site and two sub-sites under the parent. Both the sub-sites currently have similar custom list (say Contact). The data to be added/edited in both the sub-sites is same. But user base of two sub-sites is different.
The requirement is to have ability for user like admin to add/edit data in one sub-site and it should reflect in other site as well.

I can move the custom list to parent site. But how do i access the parent site list in sub-sites. I looked into option of content query webpart, but its displaying only Title column. I tried option of adding other columns in the list, but was not successful. I also need sort and pagination option in the view.
I tried using Jquery by looking into another link, but thats taking long time to load. Plus, it didnot have sort/pagination.

Any pointers on this will be really helpful.

 

Answer 1

A couple of options:

1.  you mentioned trying to modify the content query web part, so here's Heather's blog on how:
http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx

2.  Create a data view web part in sharepoint designer.  Here's a quick webcast on how to create a dvwp:
http://www.endusersharepoint.com/2009/05/12/6-minute-screencast-insert-a-data-view-web-part-onto-a-sharepoint-page/

When you're creating a DVWP, on the Data Source Library tab, there's a link at the bottom of it to "connect to another library".  When you click this button, it's misleading.  Don't put the url to a library in there, put the URL to the site itself, for the other site you want to get the list from.  Then, your data source library will be populated with the lists and libraries from a whole other site (but it has to be in the same site collection)

---

Laura Rogers, MCSE, MCTS
SharePoint911: SharePoint Consulting
Blog: http://www.sharepoint911.com/blogs/laura
Twitter: WonderLaura