What is the best way to create a dropdown of more than 20 choices?
Do not use lookup fields in a table.
Use a table containing the choices as source for combo box in your form.
The lookup table can contain as many as you need, one per record.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.