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