I have also posted this at
http://<br /> <a href="http://www.s...3355</a><br />
I am trying to create a database structure for product costing. There are several types or products and each product is made of several materials and labour.

tbProductAccounts
Account (PK) | Description
---------------------------------------
1 | This is the product type

tbProductCodes
ProductCode (PK)| Account (FK)| Description
-------------------------------------------------------------------
1A | 1 | This is a variation of product type

tbProductionAccounts
ProdAccount (PK) | Description
-------------------------------
1 | Forming
2 | Concrete

tbProductLabour
ProductCode (PK)(FK) | ProdAccount (PK)(FK) | Manpower | Hours
---------------------------------------------------------------
1A | 1 | 2 | 0.55

tbProductMaterials
ProductCode (PK)(FK) | ProdAccount (PK)(FK) | Quantity
------------------------------------------------------
1A | 2 | 2.45



Now for each labour and material entry, I of course need to apply a cost. I am not sure how to link a cost table to the above.



tbCostTable
Entry (PK) | Description | Rate | Units
---------------------------------------
1 | Labour | 28 | hr
2 | Concrete | 100 | cu.m
3 | Rebar | 3.45 | lb



Any thoughts on this?

Mike B