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!
