Sharepoint LookUp field on Choice field

lookupsharepointsharepoint-2007sharepoint-2010

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

Best Answer

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 Topic