ok. I've managed to get the data from this:
a b c d e
1.0cm 3.0 3.1 3.2 3.3 3.4
2.0cm 3.6 3.7 3.8 3.9 4.0
I'm now also able to display all this information in a table. I placed the metal and shape fields as primary keys also.
metal shape dia width weight
Cop OV a 1.0 3.0
Cop OV a 2.0 3.6
Cop OV b 1.0 3.1
Cop OV b 2.0 3.7
What I'm trying to do is have a drop down box for each field where the end user can select what they require, and then the weight show up as the result in the last box.
I've been doing a bit of reading but seem to be getting more confused on the best way to approach this.
I just need a little push in the right direction, especially with the technical terms.