Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

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

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
add comment

Your Answer

 
discard

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.