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?