Dear Colleagues,

I have a situation in which I came to an unanswered problem. I have a field which is Item Number example. 30001 with a sold qty of 12. This item is a finished product composed of two different items 90001 and 90002. What I need is to tell the system that whenever it finds a qty sold of item 30001 it has to increment the qty sold of the two components as well by the used qty which is as follows:


Finished good Components
One 30001 = to eight 90001 and also four of 90002.


Best Regards,
Emmanuel Roque

I think a finished product table is required it would have three fields Finished Product ID, Related ProductID and Quantity.

HTH