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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top