Need help on Reverse update for different level of assignation

[bondzerg]

Hello guys.

I have a coding problem on grabbing some data from the this table:

 

This image show how I has relates between products (battery) with assy and between assy and assy or components.

 

The reason why I'm having difficulties is because I need to do this kind of assignation / layer:

 

Here the explanation:

1. Let say I will create 2 products that is product a and product b.

2. In product a, i will assign comp 6 and assy 4. Under assy 4, I will assign it with comp 5 and assy 3. This goes on until lower level like in the picture.

3. Same as product a, in product b, I will assign with comp 10 and assy 8. Under assy 8, it will be assign with comp 9 and assy 7. Under assy 7, I will assign with comp 8 and assy 2 (based on assy 2 in product a).

 

Here the problem (refer to above image no. 3):

1. If I update product a with value 5, every component or assy that being assign under product a, will be update to 5. Then the difficult part is that, if I update assy 3 with value of 6, then every component and assy under assy 3 will update to 6 but not reflect to any assy or component above assy 3. Same as if I update only assy 1, the changes only on component 1 and 2 only.

2. Same as above, for product b, if I update product b with value of 4, then every assy and component under that product b will update to 4 and this also will effect the assy 2 from product a where I has assign it under assy 7 product b. Situation goes same if I update only assy 7 on product b, the changes can be see only on assy 7 and components and assy under assy 7 only where assy 2 from product a also will change.

 

* if anyone need more details on the system / php that I has done, please ask me. Thanks.