Now two requirements, one is the order, the second is material;
Material must be a separate table, including the name and quantity
Now to generate orders and each order need to fill in the material, and related materials for the quantity, how to design
I want to own the material list and order sheet, and then establish an intermediate table (order id, material id, the required quantity),
Don't know how to add good when I was in order to generate the required material and quantity in it?