The size chosen affects the price. Color doesn't, but color is tied to the productID which is tied to the price. All vpages need different recordsets(options), but I am tackling the rs OK now.
[On other pages I haven't developed yet, there are other product attibutes that the customer needs to select that don't affect the price, but that info will need to be on the checkout page (and input into my database, but I haven't gotten that far yet). For this I anticipate that I will have recordsets for the dynamic data and that can be transferred to the check-out page and my database, but my immediate problem now is for the product that has options that affect the productID/price.]
I understand from your reply that I do need one single recordset to hold all of the data that will affect the productID/price. I did create a rs earlier today to include ALL columns of data that I would need for this web page*
[* excluding quantity which I have as a separate rs with the quantity being a select list i/o of input and that seems to be working fine - multiple quantities is multiplying the price in the checkout page.]
This 1st page is a very simple rs with only 2 sizes and 1 color on this page. The result:
1. At first the dynamic lists didn't display correctly (showing the code as one of the options), but I made the following changes in the dynamic wizard in the properties inspector,
>Added Static Option label (Select),
>Options from Recordset: I choose the appropriate rs (the one with all data)
> And chose the Value and Label from that rs
>Nothing in Select Value Equal To:
This elimated the code as part of the drop down list. I include this info here because what I did may be causing my problems below.
2. In the broswer, the drop down lists include the Static Option label as the top selection in the list along with the other options in the list so it looks like:
Is there a way to remove the Static option label from the drop down list?
3. For the color, which has one option on this page, the drop down list, lists that color 5 times - the same number of options as in the size list. Naturally, I would like all lists to only list what is the selected column of the rs.
4. When I add various items to my cart, only the first option is actually added (ie when I choose size large - size small goes into check out page. When I add size Medium, it adds the quantity to the small item already in there. If I reorder the list, then it's always the first option in the rs that is added to cart. I tried binding the size value in the dynamic option in property inspector to the productID, but that didn't help. Can't figure this out.
Since I'm not sure what is causing this problem, I'm adding my rs statement, although it test out to be what I expected.
SELECT product.productID, product.desc1, product.name, product.weight, product.price, size.nameAbbrev, fabriccolor.name, size.sizeID
FROM product, size, fabriccolor
WHERE product.sizeID = size.sizeID AND fabriccolor.fabricColorID = 'Blk' AND(productID = '5' OR productID = '6' OR productID = '7')
ORDER BY sizeID
Note: As for cart appearance - think I have tackled that by making a list of things that I need to do to have appearance consistent - for me a non-coder, a better option than copying and pasting and trying to change php code. CSS and html not as difficult for me.
I hope i have explained appropriately. Look forward to hearing from you!