inventory

[Guest]

Im New to acess and not sure how to do this. Im setting up a inventory data
database. How do i put the prices in? Our prices are by feet not by unit.

 

[Guest]

Sandy,

Unless there is some mistery to your question, the problem is simple.

You should have a products table

Something like the following

ProductsTbl:
ProductID
ProductDescription
ProductSoldInUnitsOf

So then you should have a product cost table:

ProductCostTbl:
ProductCostRelatedProductID
ProductCost (By Whatever Unit Of Measure)

Next you would have some sort of table design for purchasing:

PurhcaseTbl:
PurchaseID
PurchaseRelatedCustomerID
PurchaseDate

PurchaseItemsTbl:
PurchaseItemLineID
PurchaseItemRelatedPurchaseID
PurchaseItemRelatedProductID
PurchaseItemQty


Then when you develop your forms your purchase would show your line items
with a field that multiplies your units by the cost per unit (again, what
ever that unit may be.) Note that your products table will demonstrate the
unit of measure the product is available in.


This is a crude table structure, but you should get the idea... Try looking
at the
sample database design for the Northwind.mdb.

Best of luck!