how do I create a stock control database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

sIm running a small shop and I need to have database of all stocks
available(eg jeans,ladies shoes,troussers), this should be such that, when I
sell an item, it reduces in the stocks. However Im having problems with
calculation. So, how do I make the stock database reduce as I make sales.
Please help
 
You'd have to tell us what your database looks like.

What tables do you have? What are the field?

How do you log a sale?

We can't see your tables, so you would have to describe them to us.

Rick B
 
Back
Top