Microsoft, Sharepoint, 2007, relational database capability

Posted on 2007-08-06
Last Modified: 2013-11-05
Hi All,

I'm just learning Sharepoint 2007 and trying to figure out the extent of its capabilities. Since it uses a SQL Server backend I'm wondering if "lists" can be structured as "Master-Detail". A lot of the templates seem to effectively be doing this, i.e. linking together on a common id, but I'm wondering if its being implemented in the underlying template code because when I create "lists" the only relational thing I seem to be able to do is create a "lookup" field.

Any help would be appreciated. I've gone through a couple of books but they don't seem to address this issue directly. Maybe the only way to get "relational" lists is to do custom ASP.NET programming?


Question by:birstein
    1 Comment
    LVL 51

    Accepted Solution

    Lists in Sharepoint 2007 are not intended to be a abstraction for managing relational data.  As you found yes you can relate lists using a lookup field but it is a very simple solution.

    I'm not sure if you are using WSS 3.0 or Sharepoint Portal Server 2007.  If it is SPS 2007 the enterprise version has the BDC (Business Data Catalog) for displaying relational data quickly and easily.

    Otherwise yes, you must write your won custom web parts.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now