Product table

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

Ok sorry i am very new to access. i am trying to create a database for the
small company i work for. We have products that have manufacturer dates. So i
can have one particular product code with many manufacturer or batch dates in
stock. how do i create a table or relationship that shows one product with
many batch dates with quantities? hope this makes since.
 
Something like .......
TblManufacturer
ManufacturerID
ManufacturerName

TblProduct
ProductID
ProductName
ProductCode
ManufacturerID

TblProductInventory
ProductInventoryID
ProductID
ManufacturerDate
QuantityInStock

Steve
(e-mail address removed)
 
Back
Top