Product costing

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.

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


"Bronjd" wrote in message
...
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.

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.
--
Noel J. Devlin


"tina" wrote:

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


"Bronjd" wrote in message
...
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.