SiteCollection 1 in ContentDB 1 has List 1 with custom lookup field. This lookup field returns all text fields from any selected list in a site collection specified. Each site collection is in a different ContentDB.

Site Collection 2 in ContentDB 2 has List 2 with one item.

I am getting data from SiteCollection 2 correctly. I can view the data correctly. However, i cant save the item.

I.E custom lookup field returns correct data but doesn't save. I am guessing its because I am trying to save an item from ContentDB 2 to ContentDB 1 and it doesnt exist in ContentDB1.

No errors or exceptions are thrown.

I havent had much luck on the net.

I have read that BCS would be able to solve my problem. Is there any other way? How would using SPContentDatabase help me?

I can post code if necessary.

1 Answer 1


The correct way is use the Business Connectivity Services: http://msdn.microsoft.com/en-us/magazine/ee819133.aspx

Using lists from another Site

it is the OOB way

  • I'm going to create the service. I will post details once im done. Thanks for your help.
    – Yav2881
    May 21, 2013 at 13:16
  • I ended up creating the custom of type SPField. Everything works 100%. Thanks!
    – Yav2881
    Jun 14, 2013 at 9:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.