Re: help to make database structure

From: PC Data*** (spam_at_nospam.spam)
Date: 05/17/04 

Date: Mon, 17 May 2004 14:39:53 GMT

I can help you.

Contact me at the email address below. 

--
                                         PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
"database structure" <anonymous@discussions.microsoft.com> wrote in message
news:7CAB16D3-1C02-41DE-ACC6-ED0779F61FEC@microsoft.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)
>
> Could somebody help me how to design this database? Do I need to use arrays to
make it possible?
>