Hi Jason, I have already read up on the ecart product options tutorial before I posted my question. But at first glance, I couldnt see how the tutorial would relate to my initial question (is related to "set" options"). I want the Admin owner of the website to create a product, and then create a product option thats specific to that product (so it may or may not have an additional option price and it may or may not have certain fields on a drop down list).
Also in the ecommerce sample database the `OptionPriceIncrement` is under "Product Options" - now if this is a "linking" table, then how come OptionPriceIncrement is in this table and not in OPTIONS table (for what I want to achieve in my first post, wouldnt it make sense to have a "Price" field in the same table as "OptionName" because this is where the data for any type of drop down list is stored and since each item in a list could have a price or not then it would make sense to store it here, surely? Is my logic right? or am I missing something in my way of thinking?
regards
(and hope you enjoyed your presidents holiday)
Chris