Dear All,
I have a small database which has two tables, table A = Stock and table B = Sold, these both has same fields including quantity,
I have all my items in stock table, but what I want to do is when I sold something and entered in sold item so that Item should be deducted from the stock, Exp, I have Dell Laptop and many others laptops in my stock table, but when I sold one laptop and entered that in sold item so the exact item should be deducted not rest.
Your assistance would be helpful to me and I would be thankful of you all.
thanks
Sayed Amin