Hot to set up Multi-UOM

[cap.zadi]

Hey there,

I would call help for "Multi Unit of Measure" set up with Items table.

I have a table called "tblItem"

PK ItemCode
ItemName
Type
Weight
UOM
Status
Length


tblUOM
pk ID
UOM


* if i have a item called A10101 and its having two UOM's

like one is Pc's and the 2nd one is in Meters where as i knows its 1Pcs is equal to 2 Meters.

so in some cases i need to use pc's and some where meters. so how can be work with convertion factor.


please advise.

zee

[cap.zadi]

Hey there, still waiting for help?

[dblife]

You could use a junction table to show multiple ways to measure but you might be making a rod for your own back when it comes to calculation and display later on in forms etc.
Better to decide which unit is more appropriate and just use one UOM in my humble opinion.

[cap.zadi]

Thanks man.