Hi, Is is possible to make a lookup field that links to the "Name" field in a document library? Currently it only wants to lookup to "title", but in a document library that field is empty.

Hi thereYou cannot lookup into Name even though it is the primary key field for the document library, just as Title is the primary key for other kinds of SharePoint lists. In my opinion, it is a best practice to fill out the Title field of documents and Lookup into that field. Therefore, I would firstly ensure this field is set to required on entry, and also update all the Titles to reflect the Name column.Hope this helpsCheersGeoff

Hi Geoff, Yes this worked indeed... allthough it is a strange solution for sharepoint i think. now there is a name field and a title field, which both contain the same value.

Hi, I am sharing a tips with. First of all we need to know a little on SharePoint lookup fields before proceeding further. Lookup fields are the reference fields created in any SharePoint list or library which provides a mapping between columns from another list i.e. it is just like a foreign key which helps build relationship between lists. While developing custom solutions there is often a need to retrieve data from a list or update data in a list but it's a bit different when the task is performed for a lookup field. Generally lookup data are stored as ID - Name pair separated with some special characters (i.e. ID;#Name). In this tip I will try to provide some code samples in VB.Net which will help retrieve / update lookup data of specific list. To illustrate the things I will be using a "Contacts" list which will be having "CompanyName" as a lookup field from "Companies" list. Hope you find this tips useful and of assistance. Thanks, Eliza Cheers, Eliza