Good morning, friends,
I have a project that basically has two types of products, simple products such as market items, kg rice, 1 kg beans, etc. and compound items such as basic baskets, made up of simple items, ie inside the basket basic we have rice, beans .. etc, I have a table that keeps the register of simple products, I have another table that saves the compound products and the simple products that are associated with it, and I also have a table that saves the history of outputs of the products, but in the case of a composite product it only saves the code of the same and the quantity that came out, how can I do for the output of a compound product the simple items that form it are also debited, how can I model my bank for such?