Retrieve reference for list from Lookupfield

Question

I have a sharepoint 2007 and in a document library eventhandler: in ItemUpdating, i would like to be able to retrieve the value by id's from lookupfield. So with other words i have to get the reference to a list to which the lookupfield is bound, to be able to get the values from there.

Any idea how to do that?

I have this:

SPField field = properties.ListItem..GetFieldByInternalName("InternalNameField");

I get the field, but how can I get the reference to a list to which it is bound? I couldn't find that this object has any properties like that.

Answer 1

You must cast the field to a SPFieldLookup. This object has members like

• LookupList,

• LookupField and

• LookupWebId

  that will help you identify the correct list and field

See the MSDN documentation here

Answer 2

Try this code:

SPFieldLookup spfl = yourListName.Fields["yourFieldName"] as SPFieldLookup;
Guid _Guid = new Guid(spfl.LookupList);
SPList list = yourWebSiteName.Lists[_Guid];
foreach (SPListItem item in list.Items)
{
     if (item != null)
     {
          Console.WriteLine(item.ID);
          Console.WriteLine(item.Title + "\n");
     }
}