Starting to get frustrated. A lot of these problems went away by
- Using checkboxes instead of menus since they were boolean values and I had two fields using the same lookup table which was causing the wizard issues. That should be fixed though. I think I would have found more problems when I looked at the code.
- Not including the search form on the results page.
BUT, the joins from having previously used the menu/lookup table for those fields was still spit out in the recordset and in the results table, so it cached that somewhere and failed to update when the lookup tables were removed from the equation.
It would also be nice if one could use a purely manual (non-database) menu. In other words, all static options.