Fetch data from another list

Question

Is it possible to  fetch the data from one list to another list in SharePoint 2013?

If possible how we can do this?

---

Jey

Answer 1

Yes, when you create a new column in a list you can choose a "look up" column and it allows you to select the list name and then the column name within that list you want.

---

Brendan Lee

Answer 2

there are couple of ways to do plus Brendan mentioned.

check this one http://www.sharepointdevelopment.me/2011/06/passing-data-to-and-from-sharepoint-modal-dialogs/

or 

Parent Child list: http://geekswithblogs.net/SoYouKnow/archive/2010/12/16/creating-a-sharepoint-parentchild-list-relationshipndash-sharepoint-2010-edition.aspx

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/e7c78d8f-04d7-4227-9852-8066a06b540c/how-can-i-display-the-lookup-columns-from-another-list-on-this-lists-custom-edit-form?forum=sharepointcustomizationprevious

---

Thanks -WS SharePoint administrator, MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog *Please remember to mark your question as "answered"/"Vote helpful" if this solves/helps your problem.*

Answer 3

Yes, when you create a new column in a list you can choose a "look up" column and it allows you to select the list name and then the column name within that list you want.

---

Brendan Lee

This is correct! Just remember though Out of the Box it will let you look up inside the given site contents

---

AJ MCTS: SP 2010 Configuration MCSA: Windows 7 If you find this post useful kindly please mark it as an answer :) TY

Answer 4

We need to fetch the list data from child site to another child site.

we know using the site column in top level site but really we need get the list data from child site list.

ex: we have Top level site  and two sub site (sub site 1,  sub site 2) we need to fetch the list data from sub site 1  to sub site 2.

How can we do this?

---

Jey