how do I create a stock control database

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
 
R

Rick B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stock Control Database 1
Inventory levels in stock control database 5
create a small stock control and sales database 7
How do i set up an access program to help with stock control 1
Early stages of shop-stock database design 3
stock control 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Help with Creating a Database. 2

Top