Do I need a self join 1

[EckyThump]

Looked everywhere and can not seem to find the answer, although I thinks its quite basic.
I am wanting to build a car maintenance type database that will help a beginner to do the tasks.
There are many tasks, but each task may and usually does involve other tasks.
For example: the task(1) to change the brake disk involves two other tasks: Task(2)jack car and Task(3) remove wheel.
I want to be able to select the task and show all related tasks preferably in the right order.
I tried copying the task table and creating a join between TaskID and RelatedTaskID and it shows the related tasks, but each task has other related tasks, for example, task(3) needs task(2) done first, but the RelatedTaskID field is already used.
See sample
I am struggling with this one, and would appreciate some advice to get me started I would be grateful!

 

[PHV]

Have a look here:

http://sqllessons.com/categories.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

Have you considered an additional table?

[tt]TaskID TaskID Order
1 3 3
1 7 1
1 41 2[/tt]

 

[EckyThump]

Thanks PHV thats extremly helpful and looks like it will do the job I want. The problem then comes when trying to list all the tools to carry out the master task (i.e. all child task tools!)