Help with tree view display of the form

[TravelingCat]

Hello,
Here's my db structure: There are events, each event can have several assignments, each assignment can have several sub-assignments, each sub-assignment can also have several sub-assignemnt and so on, like an endless loop of assignments. Sub-assignments are taken from the same table that assignemnts are taken from, tblAssignments, they just have "assignFatherId" so i can tell that they are sub and which assignment is their father. Now the big problem is how in the world would i display that on screen? The boss wishes to see something like tree view display, something like that:

(num) (description) (open date) (responsibles) (due date) (status) ...
+ 320  Main assignment  18/7/10  Tom Smith  28/7/10  Open 
--- 321  Sub assignment  19/7/10  Mike Cole  25/7/10  Open
+ ...... ..... ........ ...... .....
 

So it has to be multiple columns tree view, that will display all the fields assignment has from the table. I'm not even talking about the fact that the tree has to be right aligned, which i don't think is possible from what i read. So then what technique can i use? If anyone has an idea about how to display this mess i would really appreciate it, cause i'm lost.. if there's a need i'll provide more details.

[TravelingCat]

I forgot one thing, each assignment and sub-assignment also can have several reports