Question Regarding Visual Basic

[Guest]

Hi



Im trying to create a stock management system in Access 2007. At the moment
I have a dockets table (where I insert data, of the shoes that I have sold).
And a current stock table (which shows all my current stock).

I would like the current stock table to alter every time I enter data into
the dockets table. For example, if I sold a shoe, then this would be deleted
or quantity changed in the current stock table. I have created relationships
between the two tables (there is a one to many relationship on the ID column).

How would I go about doing this using visual basic in microsoft access 2007?



Thanks for all your help, Louisa.

 

[Guest]

Hi Louisa,

You generally don't store something that you can calculate. you would be
better off implementing some sort of function to give you the current
available, by adding the "incoming" shoes and subtracting the quantity of
"sold" shoes.

Naturally this will require some kind of transaction table. You already
have your outgoing transaction table (I assume your shoes come up as a line
item on the invoice), therefore you just need to have some way of recording
incoming shoes. You might do this through the same table (ie: have a buyin
customer and credit shoes to the store, similar to what you might do with a
return).

Hope this helps.

Damian.