Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 18, 2022 09:29 AM
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.
Solved! Go to Solution.
Jun 18, 2022 11:30 PM
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
Jun 18, 2022 11:30 PM
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
Jun 27, 2022 07:09 AM
Thanks a lot. :facepunch:t2: for the help :slightly_smiling_face: