Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

'Look Up ' Options

  Asked By: Jeana    Date: Sep 18    Category: Sharepoint    Views: 1101

I have a question about 'look up' options in sharepoint. I was
wondering if sharepoint could be designed in such a way that items in
List B lookup would ONLY appear if they pertained directly to the
chosen item in List A lookup.

Example...We are using sharepoint as a place to enter some basic data
using look-up lists, among other things. Unfortunately, some of our
look up lists are quite long. We were wondering if it is possible to
link the various look up lists. For example. If you choose item A
from the look up list in Column 1, then only those items pertaining to
item A will show up in the look up list in column 2.

Not sure if that is clear... any thoughts?



5 Answers Found

Answer #1    Answered By: Cornelius Guerrero     Answered On: Sep 18

Unfortunately, no, SharePoint doesn't have this functionality out of the box and
there aren't many options. Here is a blog entry pertaining to the subject:

SharePoint just wasn't meant to handle relational systems.

Answer #2    Answered By: Roderick Wolfe     Answered On: Sep 18

I will confess to being a novice in this discussion, but I also
understand that numerous corporations are using SharePoint as a web-
based interface for their ERP systems such as Oracle, SAP, Navision,
etc. which are all, of course, relational.

If SharePoint doesn't handle relational systems, how is this
integration with relational ERP systems being achieved? Any
recommended reading for a novice on that front? With many thanks!

Answer #3    Answered By: Johnny Cruz     Answered On: Sep 18

SharePoint lists  are not relational, but it is common to have custom
webparts that are front ends to back end relational systems.

Answer #4    Answered By: Norman Santos     Answered On: Sep 18

MOSS 2007 also has a new feature called the Business Data Catalog which
allows you to create integrations with databases and web services for
accessing these sorts of systems. The BDC includes a number of OOTB web
parts and the "application definitions" are XML so no custom
programming is required.

Answer #5    Answered By: Walter Stone     Answered On: Sep 18

I'm also new to this...could you explain what 'front ends to back end
relational systems' are? Can you refer me to some reading on the

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