Product table

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.
 
S

Steve

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

Top