Incremental counter for Sub Tasks

[radder33]

I am creating a small internal database for tracking projects etc. I have set up so that the project is assigned an ID upon entry. For example A_1 would be for Admin IT_2 for IT etc.

As each Project will have sub tasks I need to then assign task numbers in increment starting from 1

So A_1.1 A_1.2 etc but I don't know how to reset the incremental counter for each project. Any help on this would be great thanks.

 

[Andrzejek]

You can have one table for Dept:[pre]
ID Dept
1 Admin
2 IT
3 Sales
...[/pre]

So you can have your Other table:
[pre]
AutoNum DeptID Task ...
1 1 0
2 1 1
3 1 2
4 2 0
5 2 1
6 3 0
[/pre]

Where AutoNum is your PK, Dept points to which Dept the record is for, Task (default to 0) shows Taks 0 is the 'main' task, Task(s) 1, 2, ... are your sub tasks (which you would increment in code when the task is added)

Would that work for you?

Have fun.

---- Andy