I also just noticed that
when adding produt options ie rsColor the part I pasted into the sql has optiongroupID ='color' I fill out the rest and the new one shown shows optiongroupID =1 mine does not show that..
it shows
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
what did I do wrong.....