Hi all,
I am trying to resolve this recurseive situation:
CONTEXT: a industry produce a complex article (like a car), a car is constituted of many parts (motor, etc.), motor is constituted on other many parts, and so on ...
To save data I think a minimal table like this:

TABLE PARTS
1 - id_part
2 - id_parent_part
3 - quantity

QUESTION:
How to manage the tree structure that result from a similar situation ?

I know, this is a complex but common problem, could you help me with any idea or experience ?

T.I.A.