Convert a standard SharePoint lookup column to a full blown cross site lookup using javascript only
Guest Author: Alexander Bautz
SharePoint JavaScripts
I have updated the tool described in this article with some new functionality.
The functionality I will describe here is the ability to convert a standard SharePoint lookup column to a cross site lookup column using javascript/jquery only!
Download the script from the above referred article. Create a Lookup column in your list and have it point to the actual list it is created from (it is in fact not relevant what list you point it towards). Load the script from the above described article and select your list:
Images

Select the list

Modify the web and list association and hit “Save”:

NOTE: The web selector is only available for site collection administrators.
If you are a non site collection administrator, you may change the list association, but not the web association.
This method requires NO modification to the field schema and is fully compatible with Data sheet view etc.
I have not had the chance to test it in SharePoint 2010 yet, but I can see no reason why it should not work.
Alexander
Guest Author: Alexander Bautz
SharePoint JavaScripts
Alexander Bautz is a SharePoint consultant/developer (mainly JavaScript/jQuery solution) living in Norway. Alexander spends a lot of his spare time blogging on the same topics. His focus area is "end user customizations" with no (or as little as possible) server side code.
- Add character or word count to SharePoint multi line plain text field and restrict input length
- Autocomplete for SharePoint people picker
- Edit SharePoint Field properties, including lookup column list association, with client side code only
- Convert a standard SharePoint lookup column to a full blown cross site lookup using javascript only
This looks lovely. What does it do?
Hi,
A standard SharePoint lookup column can only pull values from list in the same site. By using this solution, you can have the lookup column pull values from any list in the site collection.
If you are in the root site, you can pull information from any subsite and if you are on a subsite you can pull information from the root site or any other web within the site collection.
Alexander
OH I see now, It’s a pointer to here. Sorry !
http://sharepointjavascript.wordpress.com/2010/03/30/edit-sharepoint-field-properties-including-lookup-column-list-association-with-client-side-code-only/
I need some more help…..just found this, tried it, but apparently I’m not doing something right, because the pieces are not syncing in.