Microsoft, Sharepoint, 2007, relational database capability

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?


Who is Participating?
Ted BouskillSenior Software DeveloperCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.