I'm not sure thisis the right place

[RJL1]

I'm not sure thisis the right place but I'll give it a go. I have been asked to produce a project managment database. This DB will be used to track different projects in our comnpany. Each project would have multiple tasks that are required to be completed in order to finish a project. In addition each task may have sub tasks. This would be tasks that have to be completed in order to complete the parent task. I have most of the work done except fot the task numbering. My boss would like to have a numerical value assigned to each task in a project and a letter assigned to each subtask. For example Project Alpha

Task 1 - deploy desktop computers
a - purchase computer
b - install network cables
c - install client application

Task 2 - Develop ID badges
a - take employee pictures
c - print & laminate employee badges

Each project would start with task 1... and each sub task would start with a... So if I have Project Beta the first task would be 1... and the first subtask of each task would be a...This is why I cannot use autonumber. Any suggestion on how to tackle this will be appreciated.

Thanks in advance
Ricardo

 

[mpastore]

Don't use alphas for sub-tasks, use numbers. You will run into sorting issues if you go beyond "Z". You can always concatenate major/minor tasks to give the appearance of indexing:

Task 1 - deploy desktop computers
1.1 - purchase computer
1.2 - install network cables
1.3 - install client application



Mike Pastore

Hats off to (Roy) Harper

 

[RJL1]

I will go woth the 1.? forthe sub task so if anyone has any suggestins on how to do this. I'm not an Access guru so apart from a few expressions and some minor VBA code I really do not have any programing knowledge.


Thanks
Ricardo