Automatically number task on various levels

[Guest]

I've created a 'Tasks' database in Microsoft Access 2003 to help me keep
track of project tasks for the Credit department of a local bank.

There are 4 'levels' of tasks, similar to tasks in Microsoft Project
(example below):

1. Create the Credit Environment
1.1 Create Process Maps
1.1.1 Personal and Business Banking
1.1.1.1 Overdrafts
1.1.1.2 Home Loans
1.1.2 ...
1.2 ...
2. ...
2.1 ...
etc.

Each task has a number, name, description, is assigned to a specific person,
has a priority, status, start and finish date.

Is there a way in Access to select the level I want to add a task to, and
then automatically number the tasks on the various levels?

Thank you in advance.

 

[Guest]

Why not add a field for level?

You need to have each layer in a different field and concatenate for display.
Your method will sort this way --
1.1.1.1 Overdrafts
1.1.1.12 Boat Loans
1.1.1.2 Home Loans