Forum Discussion
Unable to edit list items for dropdowns in Access
I created a table with many fields in Design View with data type Short Text. Even though I wanted dropdowns, I did not like going through the Lookup Wizard for every item and figured I would go back ...
First, few experienced developers ever incorporate Lookup Fields in tables. When I read stories like this--relating problems in attempting to use them--it confirms the wisdom of that decision NOT to get trapped by them.
Replace them with standard foreign key fields and forego the extra work and frustration.