Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Linking data

  Asked By: Russell    Date: Mar 22    Category: Sharepoint    Views: 861

When I am using a column which is reading a "LookUp" list
(information already on the site in some other list), how can I get
other fields to auto- populate the current record whcih I am entering.



7 Answers Found

Answer #1    Answered By: Jerrod Collier     Answered On: Mar 22

You may choose one and only one field from the lookup  list. However, the
ID is actually stored and using connected Web Parts you can be used to
present the any fields  you want from the related record.

Answer #2    Answered By: Jacob Green     Answered On: Mar 22

Related to this: I have a user who wants to have several lists on one page that
pull their data  from various other lists on the site  (to have a kind of
dashboard summary page). What's the best way to do this?

Answer #3    Answered By: Spencer Bradley     Answered On: Mar 22

Create a new Web Part Page in the database (using the browser or
FrontPage) or as a direct mode ghosted page in the Site Definition
(requires a file reference in the ONET.XML file). Then simply drag and
personalize Web Parts for each list  onto the new page for users to view.

Answer #4    Answered By: Jay Ruiz     Answered On: Mar 22

I should clarify, some of the lists are on other other sites. Is there a way to
grab those lists as well?

Answer #5    Answered By: Graham Ingram     Answered On: Mar 22

There are several ways, although none are necessarily intuitive:

-Page Viewer Web Part (clunky)
-Web Capture Web Part (not quite as clunky)
-Data View Web Part using the Manage Catalog... option from the bottom
of the Data Source Catalog task pane in FrontPage (very nice if in the
same Site Collection)
-Data View Web Part calling the Lists.asmx Web Service (my current
favorite; works in all scenarios)

Answer #6    Answered By: Donte Jefferson     Answered On: Mar 22

In the original post there was a question about "auto population" of
fields in a list, ie

> When I am using a column  which is reading  a "LookUp" list
> (information already on the site  in some other list), how can I get
> other fields  to auto-  populate the current  record whcih I am

I am not sure if this explicit question was answered, or if it was I
did not understand the answer.

I also have been trying to auto-populate fields in a list  as a way to
ensure data  integrity but have thus far failed to find any solution.

My idea was to have an default.aspx form for data entry and within
that form have a number of fields which were reliant on a secondary
data source, ie another list maintained by a few ops staff. At a place
in the entry form I was to offer the user a choice from a drop down
menu and then auto-populate several other fields based on that choice,
using the choice to 'filter' the secondary data source (this is one of
the way Web Connections work as I understand them), but I don't
understand how to use the filtered data to auto-populate the fields in
my primary data source.

Has anyone successfully used this, or a technique like it within the
portal, and if so how ???

I am relatively new to MS Sharepoint Portals and perhaps am missing
something obvious. I would appreciate any (detailed) guidance.

Answer #7    Answered By: Beau Pena     Answered On: Mar 22

I have not encountered a native SharePoint feature like the
auto-population you described below. However, I could imagine a scenario
where client-side JavaScript could be used to create such a solution.

Otherwise, you would be looking at recreating SharePoint's entire
ListFormWebPart functionality. Certainly an excellent opportunity for an
enterprising third-party company. But I haven't seen anyone step up to
the plate yet.

If you do decide to code such a Web Part, I'd like to talk with you
about partnering with our company. The replacement Web Part would need
to provide other features like filtered LookUp lists, LookUp lists from
other sites, dependant LookUp/Choice lists, etc. But I'd applaud the
entry into the commercial space.

Didn't find what you were looking for? Find more on Linking data Or get search suggestion and latest updates.