Thanks for that, it clears up a bit of confusion on my end. This recordset is too complex for Dreamweaver to translate properly. If you would like to make changes to the recordset you would need to manually edit the sql that you posted here. If you just want to include a new column that is not specified you should be able to just add it in without issue so long as that column exists in the table.