This form has multiple fields but 2 in question (this is a simplified version of what is required):
1.) Combo box with multiple choices values:
Choice Value
Choice A = A
Choice B = B
2.) Details of either choice kept in multi-column database table:
Choice, Size, Weight, Color, Shape, Price, Discount, Total
A, 10, 1, Gold, Circle, 40, 5, 35
For question 1 when the user selects choice A, question 2 should display the details of A.
I know I have seen examples of this either in the forum or a demo but I can't seem to locate them. If you know of an example I would be grateful if you can point me in the right direction.