Size and Color charts

I've created a style, size and color matrices and I want to get the chosen values into the orderdetails table. I've added the proper fields...DetailStyle, DetailSize & DetailColor.

I've also created 3 tables for the style, size and color options. I created 3 additional columns in my ecart object where each is an id integer. The id for each corresponds to the style, size and colors available for the product.

My problem is:
Instead of choosing the lets say v-neck of a list of 3 styles.
Small in a list of 5 available sizes.
Black in a list of 3 available colors.

I'm getting the id of the list that is stored. I want to store V-neck, Small & Black instead.
How would I do this?

in the drop down lists for the options, set the values to use the name column instead of the id column

The pull down is showing up fine.
Here is what I'm getting:
productcolormatrix - database table
colorID colorGroupID color
1 1 White
2 1 Black
3 1 Blue
4 1 Gray
5 2 Pink
6 2 Green

For the list I'm sorting my colorGroupID where all the 1s are grouped.
The list shows up fine but if i were to choose Blue as my color option a 1 is inserted into the ordersdetail table in the color field instead of Blue. I want to grab and insert the color name instead of the colorGroupID.
Thanks

when you create a select list option, there are two parts, the value and the label.

the label is what is displayed to the user, the value is what is posted with the form.

Change the value to use the name column just like the label.

That's what I'm doing. The pull down looks fine. It's just not inserting the name in to the database when the checkout is submitted. It's inserting the colorGroupID instead.

can you post a copy of your page.

store.php

please add the store.php page to a zip archive so i can examine the code.

Here ya go.

in the add to cart button, set the Color, Size and Style column to be updateable from a select list. This will have eCart create select lists on your page use these select lists instead of the ones you created.

Set them to use the recordsets that exaist on your page already, this will pass the form velues to the cart.