Skip to main content

SharePoint 2013 - Create LookUp field From Parent Site Collection in to Child Site Collection

Dear All, 
If you want to call any parent site collection list information in to child list collection look up column then here is a solution for it:

Step 1:
Open your parent site collection 

Step 2:
Go to Site Actions > Site Settings

Step 3:
Under Galleries select Site Columns

Step 4:
Click Create at the top of the list

Step 5:
Give the column a title you will reference in your "child" lists

Step 6:
Select Lookup as the column type

Step 7:
Select the site's column group to categorize the new column

Step 8:
Select the list to lookup from the "Get information from" dropdown

Step 9:
Select the column of the lookup list you want to reference as the key in your "child" lists

(I selected "Title (linked to item)" so that you can easily reference the parent item from your child list item)

Step 10:
Click OK


****************
Now come back to your child site collection where you want to use this information and do the following steps

Step 1:
From the All Items list vies, select Settings > List Settings

Step 2:
At the end of the Columns list select Add from existing site columns

Step 3:
You can filter the selections by selecting the group you associated the parent column with from the dropdown

Step 4:
Select the site column you created above and click the Add button

Step 5:
Click OK and there you have it.

I hope it solve your issue

Regards
Rashid Imran Bilgrami
CEO Best visualization
http://www.bestvisualization.com

Comments

Post a Comment

Popular posts from this blog

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code   protected override void OnInit(EventArgs e)         {             base.OnInit(e);             InitializeControl();             // Register the ScriptManager             ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);             if (scriptManager == null)             {                 scriptManager = new ScriptManager();                 scriptManager.ID = "ScriptManager1";                 scriptManager.EnablePartialRendering = true;       ...

SQL SPLIT FUNCTION or String_split sql function alternative Very Information (Solved)

Dear All,  Today i created a form with the checkbox list and store the value in the sql with comma seprated way. It was strange for me that the split_string function is not supported in sql 2014, so i have created split function that will help to split the comma sepearted values   CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))      returns @temptable TABLE (items varchar(8000))      as      begin      declare @idx int      declare @slice varchar(8000)      select @idx = 1          if len(@String)<1 or @String is null  return      while @idx!= 0      begin          set @idx = charindex(@Delimiter,@String)          if @idx!=0              set @slice = left(@String,@idx - 1)          else  ...

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com