help to make database structure

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?

I can help you.

Contact me at the email address below.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"database structure" wrote in message
...
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?

You need a table to store all possible colors:

tblColors
ColorID
Color

Now, you need one to show which colors the order consists
of:

tblOrderColors
OrderID
ColorID

For designs, it's very similar:

tblDesigns
DesignID
OrderID


tblDesignColors
DesignID
ColorID


Let me know if that gets you headed in the right direction.


Chris Nebinger


-----Original Message-----
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?

.