Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Populating a drop down list from a db

  Asked By: Brendon    Date: Jun 07    Category: Sharepoint    Views: 1748

Does anyone know how to populate a column within a sharepoint list
from a database querie? So basically, I want to create a list that
has a lookup column, but it pulls the info from an external
database.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Felipe Osborne     Answered On: Jun 07

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.htm

Good Luck

 
Answer #2    Answered By: Steve Fernandez     Answered On: Jun 07

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).

 
Didn't find what you were looking for? Find more on Populating a drop down list from a db Or get search suggestion and latest updates.




Tagged: