Hi,
Could I ask further question?
If I decide to have seperate tables for item and sizing, then how could I show the item qty in this format without hardcode the size in report since the sizing for each item may not be same?
Item S M X XL XXL
------------------------------------------
ItemA 1 2 0 0 10
ItemB 0 0 0 1 0
Or
Item S |M |X |XL |XXL
-----------------
5 |6 |7 | 8 | 9
------------------------------------------
ItemA (Clothe) 1 2 0 0 10
ItemC (Shoes) 0 0 0 1 0
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...