Solved

Add Lookup column to documents doesnt work.

Posted on 2011-02-21
6
268 Views
Last Modified: 2012-05-11
I did the following

Created a new lookup column, then selected Documents.

Then in Documents I uploaded many files, as its a publishing site, they were as draft.

Then I selected one and click on Publish, then the workflow started.

Then I went to Tasks, and approved it.

Then I went to documents I saw the file was approved, the only difference is that in the Modified By Field, its not the logged in user, but SHAREPOINT\system.

Then I went to the list, created a new item, the documents field is empty, nothing to select.

 

Any idea?
0
Comment
Question by:LuisEstebanValencia
6 Comments
 
LVL 14

Expert Comment

by:GeorgeGergues
Comment Utility
What is the Source of lookup column ?

another list or another Document Library ?

What is the Column you are looking for (ID , Title ..etc) ?
0
 
LVL 6

Accepted Solution

by:
Rafael I earned 250 total points
Comment Utility
In list settings, under advanced settings, see if you have the option selected for "users can only see their items" enabled.  That might be preventing you from seeing the document since it's no longer "yours" it is the system's.  Also, check that you have permissions to see all the documents
0
 
LVL 4

Expert Comment

by:webmaister
Comment Utility
Which field are you selecting in the documernt library as the lookup column?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:LuisEstebanValencia
Comment Utility
title
0
 
LVL 14

Assisted Solution

by:GeorgeGergues
GeorgeGergues earned 250 total points
Comment Utility
very good.

make sure that the items have a title in that list or library.

you can select an item in the lookup list and select edit properties.

0
 
LVL 6

Expert Comment

by:Rafael I
Comment Utility
if your documents are checked out, check them in.  That would prevent other people seeing them, even if they have rights to all the documents.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now