locked
Sharepoint and Cross-Site Lookup RRS feed

  • Question

  • Hi all

    I have this scenario

    I want to build two sharepoint 2007 sites. One for customers info and the other for products and

    customers orders.

    Now the problem is that in the second site I need to reference the customers info from the first site but unfortunately sharepoint doesnot provide out of the box cross-site lookup.


    Mina ------------- http://www.learn-mvc.blogspot.com/
    • Edited by Mike Walsh FIN Tuesday, March 23, 2010 4:24 PM Entire section about SharePoint 2010 removed. These are pre-SP 2010 forums. Post 2010 questions to a 2010 forum. What I left is a 2007 question.
    • Moved by Mike Walsh FIN Tuesday, March 23, 2010 4:24 PM admin q (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    Tuesday, March 23, 2010 4:11 PM

Answers

  • There are many third party solutions or code samples such as this: http://philwicklund.com/archive/2009/09/08/sharepoint-cross-site-lookup-columns-with-jquery.aspx

    • Marked as answer by GuYuming Friday, April 2, 2010 8:36 AM
    Sunday, March 28, 2010 6:22 AM
  • I have this scenario


    Uhmm If you want to lookup in other site I would make Site Columns(site actions>site settings) add those coulmns to ur list. Now if the Site columns are on ur parent site your child can lookup to it.

    Also then you doesn't have to create a lookup field just add the site columns to ur list on the child site. Parent site can be the Mainsite. 

    This isn't possible with list columns.

    • Edited by Mike Walsh FIN Friday, April 2, 2010 8:49 AM Don't use full quote
    • Marked as answer by GuYuming Saturday, April 3, 2010 1:07 AM
    Monday, March 29, 2010 8:23 AM

All replies

  • There are many third party solutions or code samples such as this: http://philwicklund.com/archive/2009/09/08/sharepoint-cross-site-lookup-columns-with-jquery.aspx

    • Marked as answer by GuYuming Friday, April 2, 2010 8:36 AM
    Sunday, March 28, 2010 6:22 AM
  • I have this scenario


    Uhmm If you want to lookup in other site I would make Site Columns(site actions>site settings) add those coulmns to ur list. Now if the Site columns are on ur parent site your child can lookup to it.

    Also then you doesn't have to create a lookup field just add the site columns to ur list on the child site. Parent site can be the Mainsite. 

    This isn't possible with list columns.

    • Edited by Mike Walsh FIN Friday, April 2, 2010 8:49 AM Don't use full quote
    • Marked as answer by GuYuming Saturday, April 3, 2010 1:07 AM
    Monday, March 29, 2010 8:23 AM
  • Hi, PW19, i may misunderstand your solution. Do you mean to put the URL to the parent item into a column of type hyperlink in the child list?

    For example, add the URL http://SharePointServerName/Lists/Parent/DispForm.aspx?ID=3 to a column in child list?

    Friday, April 2, 2010 8:43 AM
  • Hi GuYuming,

    It was like this you make a Site Column(use groups to easy select) on the parent add data to it. After that add the site column in ur child list. This is very handly for word templates etc.

    And why I use Parent site as home for all list is for get the data to other sites. Site My company(our Main)>custumors(Main)>custumors(Child)

    PW

    Friday, April 2, 2010 10:23 AM
  • Hi, PW, Great! Thanks for Sharing! I had never though of this workaround before:

    create a Site Column of type lookup in the site settings and add this site column to the list in Child site.

    Saturday, April 3, 2010 1:07 AM
  • Hi, PW, Great! Thanks for Sharing! I had never though of this workaround before:

    create a Site Column of type lookup in the site settings and add this site column to the list in Child site.


    NP, I was on a vacation so nice that I helped you discover that.
    Tuesday, April 6, 2010 7:55 AM
  • Works great, but what if you want to lookup information on the child site from the parent site? It doesnt seem to work with this implementation....
    Tuesday, May 18, 2010 6:25 PM