Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

'Look Up ' Options

Asked By: Jeana Ratliff Date: Sep 18, 2009 Category: Sharepoint Views: 225

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?

Tagged:look up options

5 Answers Found

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

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:
http://paulgalvin.spaces.live.com/blog/cns!1CC1EDB3DAA9B8AA!469.entry

SharePoint just wasn't meant to handle relational systems.

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

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, 2009

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, 2009

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, 2009

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
topic?

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