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.

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

Quantity per Item - Linked DataBase

Hey all ,

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. t2:

But I need to add quantity to each product

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.

Page 1 / 1

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

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