Custom Code for relating data

Hi,

I have problem that I am out of my depth on with relating data. The problem is this.

I have a table that contains stocked products (Stock Table) and the Quantity of each product. The table contains a Style #, Style Size Code and many of Quantity fields. The products that this table contains are clothing items.

eg: Style #   Style Size Code Qty1  Qty2  Qty3  Qty4  Qty5  Qty6  Qty7  Qty8
       ABC1         @6-14             0        0        1       0        0        0       0        0
       ABC2         @7-13             1        0        0       0        0        0       0        0

Each Qty field represents a Quantity of a particular size. The Style Size Code refers to another field in a second table (Size Grid).

The Size Grid table looks like the following:

       Style Size Code     Size1   Size2  Size3   Size4  Size5  Size 6  Size7  Size8
         @6-14                     6         8         10        12        14      
         @7-13                     7         9         11        13
 
I need to be able to create a Summary table of Style by Quantity by Size. I the above example product ABC1 has a Quantity of 1 however the Qty field that 1 is listed in is Qty3 which should somehow relate to a Size 10 from the Size3 field in the Size Grid.

Likewise ABC2 has a Quantity of 1 which is listed in the Qty1 field of the Stock Table. Qty1 somehow relates to the Size1 field in the Stock Grid table which is a Size 7.

I have no idea on how to relate the two tables and then to show in my query each Style by Quantity by Size. Help Please!

Thanks
JStart Free Trial