Ive created the table
I am still getting the same results.
This is what my recordset reads now, what should it read
SELECT Group_Concat(Concat(OptionGroupName,': ',OptionName)ORDER BY options.OptionGroupID, options.OptionID SEPARATOR ',\\r\\n') AS CartOptions
FROM options INNER JOIN productoptions ON productoptions.OptionID = options.OptionID INNER JOIN optiongroups ON optiongroups.OptionGroupID = options.OptionGroupID
Thanks