Hi I am looking to create a stock control database. I have been working with the Inventory 2007 and Northwind 2007 databases.
I like the way that Northwind 2007 database controls purchase orders and allocation of stock.
I am looking to use the stock control database for a beauty salon in a local small college.
I have changed the database to allocate stock from stock in from purchase orders to locations rather than customers however I might want to have a part to record any stock that is sold to customers.
I am interested in have the ablity to add / remove stock from these locations as is made available in the Inventory 2007 database.
Could someone help me, I need some code adding to make it possible for me to remove any amount of stock from the locations.
The Northwind 2007 database does have a "Waste" field in the "inventory transaction types" table but there is no code that I can see that make use of this.
I like the way that Northwind 2007 database controls purchase orders and allocation of stock.
I am looking to use the stock control database for a beauty salon in a local small college.
I have changed the database to allocate stock from stock in from purchase orders to locations rather than customers however I might want to have a part to record any stock that is sold to customers.
I am interested in have the ablity to add / remove stock from these locations as is made available in the Inventory 2007 database.
Could someone help me, I need some code adding to make it possible for me to remove any amount of stock from the locations.
The Northwind 2007 database does have a "Waste" field in the "inventory transaction types" table but there is no code that I can see that make use of this.
