How do I create size charts in Access?

[DD]

I am working on setting up an access based solution. I need to create
various size charts for each Manufacturer & their respective divisions.

Would each chart be a different table? Or could one table accomodate
multiple charts?

There will be about 1000 different size charts (Oh to get the apparel
industry to a standard). Some may be simular.

Each chart would consist of: Size, Bust, Waist, Hips, Length

 

[TC]

You could store each chart as a record in the "obvious" table:

tblChart
ChartID (autonumber) (primary key)
Size
Bust
Waist
Hips
Length

But it's hard to say if that would be right, without knowing how you
plan to /use/ that data in the rest of the application. So, how do you
plan to /use/ that data?

If you're only going to print it out, it might as well just go in a
spreadsheet, or even a Word table.

HTH,
TC (MVP Access)
http://tc2.atspace.com