SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

The correct way is use the Business Connectivity Services:

Using lists from another Site

it is the OOB way

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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