Help

Quantity per Item - Linked DataBase

Solved
Jump to Solution
730 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Luis_Diogo
4 - Data Explorer
4 - Data Explorer

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

I have a database with all the products:
CleanShot 2022-06-18 at 17.25.58

Then I have a database with my orders to the suppliers linked to my product table.
CleanShot 2022-06-18 at 17.27.01
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.

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

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


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

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

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


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

Luis_Diogo
4 - Data Explorer
4 - Data Explorer

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