Wizard Dropdown menus don't update records
I have a multiple table database with several tables being used almost exclusively for drop down menu input (to minimize user spelling/typo issues).
When I create the dropdown menu's in DataAssist Wizard, they create perfectly, look great, and are completely useless.
I followed the Data Assist tutorial (which I can't find again ... GDI!!) where I learned how to make the menu dropdowns, and they worked great the first time I did it, but then I realized, I wanted the "name" not the "id" to show in the results and details pages.
I re-ran the wizard (about 12 times now) and I can't get menu drop downs to display only the name, sort by the name, etc...doing NOTHING with the ID.
I tried to add an INNER JOIN to the query at one point, and that didn't work either, although, given there is no associative table between the 2 tables, I don't think that is necessary...
Thoughts? Help? Bandage for my head or repair kit for my desk?