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

[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

Content Query Webpart Template In SharePoint 2013 and add new column in it

Dear All, Here is the easiest way to make add custom column under your content query web part and then you can format it as you want. Step 1: Open Sharepoint design Step 2: Open site for sharepoint parent site collection Step 3: Locate the following folder Style Library > XLS Style Sheets Step 4: Open "ItemStyle.xsl" file Add the custom style sheet as you want <xsl:template name="[Your Style Name]" match="Row[@Style='[Your Style Name]']" mode="itemstyle"> <xsl:param name="CurPos" /> ...

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 ...

Search This Blog