help to make database structure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: database structure (anonymous_at_discussions.microsoft.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 06:51:05 -0700

 have a simple database with following tables:

MainOrderDetails
Suppliers
Clients

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. (the no. of designs and no. of colors and quantity of each color can vary for each order)

Could somebody help me how to design this database? Do I need to use arrays to make it possible?

Quantcast