How to add multiple rows at once, specific case

Ask for Help
1

I have products, materials. Each product needs a couple of (actually more than it) materials( each material amount differs based on product). I have this saved in two tables in relation( which products requires how much of each material). Though in the case I saved, all products are in 1 unit. However, Manufacturing team might ask more than one unit. So, quantity of each element should get multiplied, and saved in corresponding request table ( Manufacturers makes requests of products). Manufacturer should choose product, and unit. So, corresponding materials with right quantity should be added to the table at once.

Can anyone help me how to do it, thank you

2

In what format are you storing requests? Say I request product A, and product A has 10 materials tied to it, then would it be 10 rows in the Requests table, or 1?