Hi,
Thank you for your great ideas. It really minimize alot of works.
I have another similar questions.
1. My application designed to handle fashion products (color and size).
Item A
+ Color Red, Size M
+ Color Red, Size L
+ Color Blue, Size M
Item B
+ Color Red, Size XL
+ Color Red, Size S
+ Color White, Size M
I want to keep track all transaction of item, ex.
Good Received 01/01/2004 : Item A, Color Red, Size M
Sales 02/01/2004 : Item A, Color Red, Size L
I want my report able to show stock qty of itemA; also Item A, Color Red, Size M ONLY.
2. How about serialno product?
How would you store it in product, and sale details table?
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...