tree product by form

[pedjvak]

Dear All
I am working in montage workshop that have some main products
and each product included some parts
and each part included some pieces
point is here i want to have a form which I search by product's code in sub form show me related parts
and then show the pieces in another sub form that related to first sub form
it means can I have product tree in one form which I can edit in the sub forms ?

[ranman256]

yes, you can edit subforms.
i see tables:

tProducts
--------------
[ProdID] autonumber
[product]
[description]

and a parts table
tParts
--------------
[PartID] auto
[PartNum] string
[PartDescr] string
[ProdID] long (FK to tProducts)
[ParentID] (what this part belongs to in the chain)

here the parts can have pieces in a self-relating table.

partID	part	parentID
1	car
2	wheel	1
3	bolt	2
4	hub cap	2

This is a more advanced concept, but parts are made of parts, that are also made of parts.