Product costing

[Bronjd]

Quite simply, I want to 'design' a database that will keep track of the cost of individual items so that I will know what to charge when I sell items made up from those purchased items. There does not appear to be such a database template within MS Office XP.

 

[tina]

suggest three tables:

tblItems
ItemID (primary key)
ItemName

tblParts
PartID (primary key)
PartName
PartCost

tblItemParts
ItemID (foreign key from tblItems)
PartID (foreign key from tblParts)
Quantity
use the two fields together to make a combination primary key.

use a query to multiply the Quantity of each part used for a specific item X
the PartCost. you can sum the cost of all the item-parts for a specific item
directly in a form or report.

hth

Quite simply, I want to 'design' a database that will keep track of the

cost of individual items so that I will know what to charge when I sell
items made up from those purchased items. There does not appear to be such a
database template within MS Office XP.

 

[Epicpic]

Thank you, Tina, as things turned out, I had the answer, anyway but was thinking too deeply about the problem I posted. Thank you again.