Project / Task tracking database HELP!!!

[RJL1]

I have created a small database calle Project Manager. We use it so people can manage their projects. The can add new projects and/or add task under each project. I have the project name and the manager incharge in one table tblProjectHeader all the task are in asecond table called tblProjectDetails. I made a test project to show the employees how ot use it so I craeted 4 tasks under my test project. The task ID is set to auto number so it assigned numbers 1-4. When i went back to add a real project which contained 4 tasks it assigned 5-8 as the task ID.

How can I get the tasks on each project to be numbered from 1 to ????. I want each new project to have a sequential task number starting with 1.

sample
Project 1
1 task a
2 task b
3 task c
Project 2
1 task a
2 task b
3 task c

I hope this is clear if not I can expand on it.

Thanks
Ricardo

 

[AccessAce]

You will need to use two identifiers. One for the Table, the other for the Task. The ID for the table should be set to Autonum, The ID for the task should be a custom made function that will count the number of tasks for a given project and return one greater than that number.

Public Function GetTaskNum(ProjectID as Variant) as Long

GetTaskNum = DCount("[TaskID]","Tasks","[ProjectID] = " ProjectID) + 1

End Function

 

[RJL1]

Thanks for the fast reply. However I'n new to the VBA end of access so I'm not sure where I should put the code you provided. Do I need to make a field for the task number and use the code in the form so it will populate the field in the table?

Thanks
Ricardo

 

[GingerR]

what if the user wants to change the sequence?
so if you put in that code, and it assigns the task seq number itself, the user must put in tasks in the exact order in which they are to be carried out. based on my experience, that ain't gonna happen ) "oops i forgot to add BLAH which needs to be done before BLAH BLAH!!"

 

[RJL1]

I'm using the Task number for reference only. The reports I have made are are sorted according to Due Date or priority which are two fields I have inb the table. Priority is assigned by the user so if they can change they priority as they see fit. The numberical sequence is use for daily or weekly updates. So the project manger can say "Give me the status on task 1,6 and 12 instead of giving the full description of the task each time.

Thanks
Ricardo