Sharepoint By Dummies

See Also:

Drill up but not down

leave a comment »

In Sharepoint 2010 Designer (SPD) once you’ve inserted a dataview you can also insert a Related Item View (another data view which is linked to the first by lookup fields).  Unfortunately it seems you can only drill up,  not down.

Suppose you have three lists: ListA, ListB and ListC.  ListB has a field which is a lookup on ListC and ListA has a field which is a lookup on ListB.  If  you put a dataview based on ListB on a page you can insert a Related Item view to link to related items on ListA (i.e. drill up) but not on ListC (i.e. drill down).  If you have ListA as the source of your dataview then you cannot insert a Related Item view, if you use ListC then you can drill up to ListB.

We discovered this on a site where we have Business Areas that use Applications which are based on Technologies.  These map to ListA through C in the above, there is a many-many link between these lists (some Technologies are used by multiple Applications and some Applications are used in multiple Business Areas).  From the Technologies list we can drill up to the Applications list (which applications use this Technology) and from the Applications list we can drill up to the Business Areas (which Business Areas use this Application), but not the other way.  The problem we have is that management want to have alerters for Applications which use Technologies that are approaching their end of support date.  this would be possible if there was a one to many join (one technology is used by multiple applications but each Application uses only one Technology) but not with a many to many or with Related Item view.

Written by stephenboothuk

February 21, 2012 at 4:38 pm

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Speeches I Would Have Given

What I would have said at conference

Mark Vale

Tech blog on Microsoft Teams & Stuff

David Hunt, PE... Mechanical Engineer on the loose!

VALUE = Creativity + Diverse Experience + Critical Thinking


A personal blog about having Asperger's

Marc D Anderson's Blog

A Knowledge Management Zealot Speaks Out

Codeless Solutions for SharePoint

Bryon Wyly is a SharePoint Developer dedicated to finding the limits to out-of the-box SharePoint solutions

the political blog of gordon lyew

SharePoint Business Analyst

Just another weblog

%d bloggers like this: