Hello
First of all my apollogies if this is not the propper place to ask this issue, but since I didn't know if it's a question concerning CCK, Views, Nodereference or something else, I thought this place would be the best place to ask.
I have two content types: Artists and Albums, and Albums is a child of "Artists". I would like to create a view that would sort all the artists and order them according to update date, I know how to do that. The problem is that I would like to change the Artists update date according to the last update in one of their childs (Albums). I'll give an example:
Imagine I have these Artists:
-Coldplay (last updated 2009/01/01) (date format YYYY-MM-DD)
-Depeche mode (last updated 2009/01/02)
-U2 (last updated 2009/01/03)
the view would sort them this way:
1) U2 (last updated 2009/01/03)
2) Depeche Mode (last updated 2009/01/02)
3) Coldplay (last updated 2009/01/01)
Imagine we add "Viva la Vida" as a new Coldplay's Album on date 2009/01/04, I would like the view to sort the items this way:
1) Codplay (last updated 2009/01/04 - that's the date when I added "Viva la Vida")
2) U2 (last updated 2009/01/03)
3) Depeche Mode (last updated 2009/01/02)
(I hope I have explained it easy enough)
Is there any way to achieve this? How can I do that?
Hope anyone can help me.
Thanks
