I have a web part that I display a data view of one list say List A (below). This list has one column as a lookup which is already another existing list say List B.
Say, List A {Project Name, ID, Stage} and List B {Stage, Phase}
(rule: many stages can exist in one Phase)
Now, I'm required to display Phase based on the Stage. Meaning I just want to retrieve the phase the stage is in at the same data view I have.
Like this: value of ( Get ListB.Phase [where] Stage = "Stage1" )
Please can someone guide me. I would prefer to do it manually without using SPD 2007 menus.
I use html, javascript, xsl, ajax.