Adding SPFieldLookup to a list programmatically ?

Question

Hi all

I added a SPFieldLookup field to a list programmatically.

when I checked my list view I found that the lookup field is as if I added it from the user inerface without specifying that it is linked to item.

is there a method to force the lookupfield to be linked to item programmatically ?

thanks

Answer 1

If you are provisioning both the list where the SPFieldLookup field is in, and the target list you will have a problem. Because the SPFieldLookup field needs to assign the target list by its GUID, which is created dynamically when the feature is activated. And you can't define this value in your field definition, since it doesn't exists yet.

The solution to this problem is provisioning both the "source" list and the target list normally, except the SPFieldLookup field in the source list.
Then, in the feature activated event, you add this lookup field programmatically, which could now be done since you have (or at least can find out) the GUID for the target list.

Answer 2

Did you fill all the needed properties (LookupField, LookupWebId and maybe also LookupList) and Update() the field afterwards?

Perhaps http://www.alexbruett.net/?p=153 will help