Design Garment Prototype Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Design Garment Prototype Database

Author

Topic

spikev2
Starting Member

6 Posts

Posted - 2008-07-09 : 10:08:53

After tearing my hair out this week and trying various options I have decided to seek some advice as databses are not one of my strongest points

First a little background, the database is to replace individual spreadsheets which hold this information.

MainGarment Table
StyleNo PK
Version PK
Customer
CreatedDate
Etc

Each style also has 2 Grids:

Grid 1 Initial measuring Points

Target Actual

Chest
Body length (LC-Welt) 58.5 59
Underarm
Skirtdepth

The various measuring points may vary from garment to garment and additional notes have to be held against each measuring point as shown in brackets above.

I have setup an additional 2 tables.

Table1 being a simple lookup table containing the measuring points.
FieldID
Description

Table 2 being the many side with the field details and measurements

Table 2
Styleno PK
FieldID PK
Version PK
Additional Text

Design tool is VS2005 and main screen is a multitabbed form.
The brick wall I have hit is regarding the 2 grids I want to have in this form.

Grid 1 is based on table 2 above which in theory is fine.

Grid 2 is similar to Grid 1 but has the extra dimension of sizes included:

Layout of Grid has to be similar to the following:

S M L XL

Chest 56 59 62

Body Length 74 75 76

Because of the laout of this grid I have been looking at commercial components and have found one that lays it out correctly if all the fields are hardcoded in one table.

But I cant seem to get the table design right.

Can anyone point me to any articles or samples or have any thoughts?

Any help will be gratefully received.

spikev2
Starting Member

6 Posts

Posted - 2008-07-10 : 06:05:34

Ok.

Because the data is too dynamic I have decided the best way to do it is to invest in the farpoint grid control for displaying the image in a spreadsheet control.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources