I have a tree that is composed on projects and sub-projects. So, my project table has the standard ProjectID and ParentProjectID.
Now, when the user selects a project, I need to go fetch all the project and sub-project related task records. What do you guys think is the best way to go about this?
Thanks!
