help to make database structure

[database structure]

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. (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

 

[PC Datasheet]

I can help you.

Contact me at the email address below.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

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)

 

[Chris Nebinger]

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?