By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,688 Members | 1,900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,688 IT Pros & Developers. It's quick & easy.

Help with tree view display of the form

P: 82
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:
Expand|Select|Wrap|Line Numbers
  1. (num) (description) (open date) (responsibles) (due date) (status) ...
  2. + 320  Main assignment  18/7/10  Tom Smith  28/7/10  Open 
  3. --- 321  Sub assignment  19/7/10  Mike Cole  25/7/10  Open
  4. + ...... ..... ........ ...... .....
  5.  
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.
Jul 20 '10 #1
Share this Question
Share on Google+
1 Reply


P: 82
I forgot one thing, each assignment and sub-assignment also can have several reports
Jul 20 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.