Projects have subprojects!

[neillovell]

Hello,
I'm developing a timesheet application. Users choose the project they are working on from a combo box on a form and enter their hours spent on the project etc.

My problem is that some projects are really subprojects of other projects. An example would be

MyProjectA
Documentation

Now documentation can be considered as a sub project of MyProjectA. But at the same time documentation can be for any other project. So I'd like to be able to class Documentation as a subproject of MyProjectA, and call it MyProjectADocumentation. Of course doing this for every project would create a HUGE list to navigate, and you'd have to manually go through the table and add up all the hours. Much better to have a grouping so total hours for MyProjectA includes documentation.

Any thoughts on how to do this?

 

[hjgoldstein]

Hi Neil.

I would set up another table with a one-to-many relationship using the primary key of the Project Table to a "duplicates OK" index on the sub-project table. Then you can use all the hours in a query to total and perform any other calculations you need.

Hope this is of use.

Howard.