If you like to create a lookup column who looks in list of other webs follow these steps:
  • create a new column in your list
    • type ist lookup
    • connect to another list of same web
  • open WSSListConfigurator
    • use url of the list to connect
    • select correct list
    • select your new field
  • now the WSSListConfigurator recognize that it is a lookup-column and show you the tabpage "Lookup"
    • select the web you want to connect
    • select the list
    • select the field which should be used to display values
    • click "Update column"

Thats all!

Last edited Dec 7, 2007 at 3:37 PM by DBedarf, version 1


dwheatcroft Sep 30, 2008 at 9:56 PM 
Are there any known limitations of this other than x64 and not being able to reference certain fields (e.g. modified by, etc.). Specifically, I am just trying to reference the "title" column on a parent site and while the tool is able to find the columns ok to reference, after saving I do not see the appropriate values in the drop down on the New/Edit/View Item pages. Any suggestions you may have will help greatly!