Add Lookup column to documents doesnt work.
Posted on 2011-02-21
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.