I have one list on SharePoint. I want to create another list and one of the columns should pick up values from the other list. However, when I create a new column and select the type as "Lookup (information already on this site) and select my old list in "Get Information from" , I don't see all the columns of the old list but a selected few. Why is that and how can I make sure that in my lookup column in the new list, I see all the columns as I need information from the other columns?

Hi there. I think is by design in SharePoint 2007. You can only do lookups to "Single line of text" columns. Hope this helps. Regards, MagnusMy blog: InsomniacGeek.com