Quantity per Item - Linked DataBase

[Luis_Diogo]

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.

[TheTimeSavingCo · Accepted solution]

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

---

---

---

[Luis_Diogo]

Thanks a lot. :facepunch:t2: for the help :slightly_smiling_face: