stock PLEASE HELP!!

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

Guest

I have a stock list, amoung which i have one product that comes in large
bulk, but every unit of that product has a specifc serial number. how do i
simplify stock keeping and most importantly, i have tried seperating tables,
but now i dont know how to total, and find remaining stock and sold stock

PLEASE HELP ME
 
Separating the tables is still the right way to go - you have one table
ProductMaster with columns:
* ProductID
* ProductDescription
* other product attributes

And another table StockedProducts with:
* StockItem (Autonumber field just to guarantee uniqueness)
* ProductID
* DateIntoStock
* DateSold

And then another table StockSerialNumbers with:
* StockItem (NOT an Autonumber in this table)
* SerialNo

StockedProducts is the table that you use to write queries for to find out
things:

Items in Stock =
SELECT Count(*) FROM StockedProducts WHERE DateSold = NULL

Items Sold =
SELECT Count(*) FROM StockedProducts WHERE DateSold <> NULL

You can find out the stock for particular days by using different Date
Criteria. To build a report, you would join it up with the other tables to
get more info.

Hope that helps,
David...
 
Back
Top