i am getting closer. I figured out that i was putting multiple values in my OptionName row, ie White,Bronze,Green, etc on one row, instead of having White on one row Bronze on one row, etc with the OptionsGroupID as '1' for each color in that group.
With your example of sql i get the values to show in browser and also show in the list/menu.
Now as a test i am showing one item and it should show 1 OptionGroup but it is showing two so i must not have it filtered correctly?
thank you very much for your help,