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?

Thanks,

Kathryn