OverView
In this post,I want to show u how to add a look up column in my list or library that looks up data which comes from a list or library of another site.
I have to say,it is a awesome Function and easy for sharepoint end users.So,Let me guide you through this .And,more remarkable,as long as you must stay in the same site collection.You can create a lookup Site Column that will be used to get information from list which is available in a parent site.The Site Column must be created in the same site as the referenced list/library.
So Let's go ahead.
Step by Step-> Create Lookup Site Column in a parent site(root website)
- Go to Site Action then Site Settings
- Click on Site Columns in Web Designer Galleries
- Click on Create and Create a new Site Column
- Type in a Distinguished name and Select the type in this column is Lookup
- Put this site column into Existing group.for example Custom Columns
- Select a List/Library as information source
- Check it Whether Exist in Custom Columns Group
- Add my Site Column to any list/library you would like to use it with.Just Click on List Settings on Ribbon Menu.
- Click on add from existing site columns
- Select site columns form custom columns
- Success.Look up column looking for values of a list/library on another parent site.
- Just click on the hyperlink as shown in below and finally pop up a dialog to show information.
- Pop up a dialog to show relevant information.
Note:When you click hyperlink . Unfortunately get a error "List does not exist.The page you selected contains a list that does not exist. It may have been deleted by another user".
To Fix this error,just install the latest update of sharepoint and the bug will disappeared.