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.


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

| 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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