unit and alternateive unit

Question

 Hi, i am working on an inventory application.

 

i am stuck at the unit conversion , like if a product is in Kilogram, i need to sell in grams or tons, dozen to pcs and  custom pack is also there like a carton may contain 20 pcs and need to sell it in pcs or it may contain 40 pcs. i hope you understand my question,

 

Product table is like

 

ProductID	Name	Rate	Unit	Baseunit	conversion
1	Item A	100	carton	Pcs	20
2	Item B	120	carton	Doz	10
3	Item C	100	Kilogram	Gram	2

  

ex: Item A is in carton of 20pcs

item C is a bag of 2 kilogram

 

and there is another table for measuring Unit

 

Unitid	UnitName	ParentID	Conversion
1	Pcs	-	1
2	Doz	1	12
3	gram	-	1
4	Kilogram	3	1000

 

like wise

 

i tried but didn't get a complete solution for this, please help