Quantity per Item - Linked DataBase

Hey all :wave:,
I donโ€™t find a solution for my stock tracking system.

I have a database with all the products:

Then I have a database with my orders to the suppliers linked to my product table.


Each order has multiple products.

Until this step is perfect. :ok_hand:t2:

But I need to add quantity to each product :confused:
2 Items of X
3 Items of Y
1 Item of Z

Do you know how I can add that?
If I insert a general #number field is a quantity for the order and not for each product item.

Thanks.

Hi Luis, youโ€™re going to need third table for line items and link it to both the products and orders, like in this base


Screenshot 2022-06-19 at 2.29.25 PM


Screenshot 2022-06-19 at 2.29.28 PM


Screenshot 2022-06-19 at 2.29.33 PM