Product costing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Quite simply, I want to 'design' a database that will keep track of the
Click to expand...
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.
 
Back
Top