sergio
New Member
Simple stock management [SOLVED]
Hi all,
Should I make a simple stock management (simple add and remove products with automatic update of the quantity in stok)
well....
I've 2 tables:
1. called:Magazzino
id_prod | descripiton | cod | quantity
2. called Movimenti
id_mov | date | id_prod (joined with the id_prod of the first tb) | pieces (added o removed)
Now, when I make a "movement" in table 2, the quantity inserted in the colums "pieces" (i.e. -2) should go to remove (in this case) the quantity of the column "quantity" oh the first table!
I've tried a lot of solutions.... but I'm still in deadlock...
can you suggest me something.....
tnxxxxxx
Sergio
Hi all,
Should I make a simple stock management (simple add and remove products with automatic update of the quantity in stok)
well....
I've 2 tables:
1. called:Magazzino
id_prod | descripiton | cod | quantity
2. called Movimenti
id_mov | date | id_prod (joined with the id_prod of the first tb) | pieces (added o removed)
Now, when I make a "movement" in table 2, the quantity inserted in the colums "pieces" (i.e. -2) should go to remove (in this case) the quantity of the column "quantity" oh the first table!
I've tried a lot of solutions.... but I'm still in deadlock...
can you suggest me something.....
tnxxxxxx
Sergio