Oh well,...
First of all, did you try doing a full set of pages in the wizard, not just one? I've noticed that this error moves around and can be on anyone of the pages where the wizard has generated a recordset for one of the 4 dropdown lists. Of course, I only have to define a RS for a DD list once and then that setting is propagated to any other pages that use that DB column.
1. I'm working on blank php pages that I'll style later.
2. the db is defined and DW connects. WA sees the db and can define RSs.
3. since this is a personal site and an new project just for myself, I'm working on the live server or to put it another way, the testing server and the remote sever are the same.
4. I'm building from the backend forward, so I've completed several smaller Admin sets using the Wiz to add, delete, and modify DB records, all of them just tiny drop downs with only two columns an ID and a Item.
This is the most complicated form set I've tried to get the Wiz to build for me.
There are 10 steps in the full wizard. Do you really want a blow by blow of each move I make?
Boy, I really miss Interakt and the DTB. Frankly, I could have saved myself a lot of time and money by just building these forms the old way with the native DW data tools.