Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Using lists like a relational database...

  Asked By: Alexandria    Date: Apr 17    Category: Sharepoint    Views: 3787

I have four lists --> goals, objectives, tasks, and sub tasks
Each item inherits a status icon from the sub item (child node). For
example, one goal has a green circle but the green circle is inherited
from the goal's objectives...if status for objectives changes to a red
circle, goal's circle turns red (this logic applies to all sub items
because they determine the status icon of the parent).



5 Answers Found

Answer #1    Answered By: Nina Banks     Answered On: Apr 17

OK, I think that I understand your scenario. Restated: When the value of
any child  ListItem changes, there may be changes to the parent. I
presume that these lists  are "related" by selecting the parent  from a
Lookup field on the child.

What is the question?

Answer #2    Answered By: Sharonda Mcfarland     Answered On: Apr 17

The child  ListItem determines the change in the parent  item. I am
currently dealing with three layers -- Parent --> Child --> Sub-Child
(not very technical, I know). A lookup to the parent can be used,
but I need an ID from the parent to connect to the child ListItem.
For example: One Goal may have a task and that task may have a sub-
task or sub-tasks, if the status  on the sub-task changes, the status
of the Goal becomes the status of the sub-task. This applies to
tasks as well. Conditional formatting will be used to show an icon
based on the status.

Answer #3    Answered By: Kalyan Pujari     Answered On: Apr 17

You will not be able to achieve these display requirements using OOB
List View Web Parts. You will need to either use a Data View Web Part or
develop a custom Web Part solution. Do you know how to do that?

Answer #4    Answered By: Christop Mcfadden     Answered On: Apr 17

I know how to develop a custom web part, but was told not to use them
in this solution (I was given FrontPage 2003, WSSv2, and the lists  to
work with). I think I may have figured out a work around with views
and connecting the all items view to two custom views I created. The
ID of the list entry is in every view and the field the web part
connection is based on. Then I added some custom xslt/xpath code to
manipulate the conditional formatting based on the child  views. It
appears to work...I just need to modify a bit more.

Answer #5    Answered By: Gopal Jamakhandi     Answered On: Apr 17

So, you opted for the DVWP solution.

Didn't find what you were looking for? Find more on Using lists like a relational database... Or get search suggestion and latest updates.