Hi
i have a database that hold sales details, i would like to add stock\inventory control to it.
I have tables set up that hold the products (this has a quantity field)
and a form that allows the user to add the amount sold or purchased.
what is the best way to up the product table after the user enters amount sold or purchased
what is the best way around it, or what is the theory, i have had a look online and tried to look at other database, but didnt get anywhere
I have attached images of the table, form and how the tables are links, if needs be i can upload the database too
Thanks in advance