A
Avir
I have a simple database with following tables
MainOrderDetail
Supplier
Client
Most of the information stays in MainOrderDetails table.
I wish to create a new table or a field to do following job (we deal in fabrics
In one field we mention no. of colors. (till now we just used to mention only the no. of colors in the database). But now we wish to mention exact quantity of each color.
So, we need some way to expand the fields according to no. of color entered by user.
2nd case is more complex
If the order is for printed fabric, user will enter no. of designs. And each designs will have some colors. We wish to store each design each color quanity in separate field.
Could somebody help me how to design this database
Any help would be highly appreciated.
MainOrderDetail
Supplier
Client
Most of the information stays in MainOrderDetails table.
I wish to create a new table or a field to do following job (we deal in fabrics
In one field we mention no. of colors. (till now we just used to mention only the no. of colors in the database). But now we wish to mention exact quantity of each color.
So, we need some way to expand the fields according to no. of color entered by user.
2nd case is more complex
If the order is for printed fabric, user will enter no. of designs. And each designs will have some colors. We wish to store each design each color quanity in separate field.
Could somebody help me how to design this database
Any help would be highly appreciated.