Does anyone know how to populate a column within a sharepoint listfrom a database querie? So basically, I want to create a list thathas a lookup column, but it pulls the info from an externaldatabase.
Here is one approach that is easy and involves no programming. It is probably not the most elegant, but it would work.If you have Front Page 2003, you can create a new list which is nothing but a view of the lookup table in SQL Server. This is easy to do but I cannot tell you the steps because it has been a while. IThen you can use the new list (above) to populate the column in the list of interest. would guess that there is information on how to do this on http://www.sharepointcustomization.com.See this: www.sharepointcustomization.com/.../default.htmGood Luck
Using Front Page 2003 you can define an external Datasource in Datasource Catalog and then you can use it as lookup. I don't know how this will fit in for a field in SP list (and interested in knowing it).