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.