Sharepoint LookUp field on Choice field?

sharepoint sharepoint-2010 sharepoint-2007 lookup
Govind picture Govind · Sep 23, 2011 · Viewed 64.3k times · Source

How to create a lookup field for the Choice field..For eg: In a list i have Choice field and i have to create an lookup column in other list pointing to this choice field ..When i select this list this column is not appearing in the dropdown...Please let me know if there is any Limitation for that

Answer

Dennis G picture Dennis G · Sep 23, 2011

It is not possible to create a lookup field for a choice (dropdown) field. There are two ways to resolve your problem: The programmatic approach and the workaround.

The programmatic approach involves an creating event receiver to do the magic - pretty work intensive. But there is an explanation here:

You can also just create another list, containing your choice field values and use a calculated field as a source for your lookup column. Check out the following explanation:

Related questions

FileNotFoundException with the SPSite constructor

I try to instantiate an instance of SPSite on the farm server in a custom process (MyApp.exe) and I give it as parameter the whole URI (http://mysite:80/). I also made sure that the account running MyApp.exe is …

Read More
How to get list of all document libraries from sharepoint site programatically

I am using below code which gives me both list & document library; but I am trying to get list of only document libraries. Please help me how to differentiate list & document library programatically using(SPSite oSite = new SPSite("…

Read More
How to add specific SharePoint Group to List permission

using (SPSite site = (SPSite)properties.Feature.Parent) { using (SPWeb web = site.OpenWeb()) { if (web != null) { web.AllowUnsafeUpdates = true; SPList list = web.Lists["Alert Status v1.0"]; //Creates a new role assignment for a group SPGroup myGroup = web.SiteGroups["IKM Manager"]; SPRoleAssignmentCollection …

Read More