You are definitely not the first person to request custom UI only dropdowns.
I understand the idea that it feels simpler since there is less work required at the database level. At the same time, I have to think that the database is the best place for these lists. Even if they are tiny. The reasons in my mind are:
- Referential integrity,
- Easy to extend with additional columns for help or extra detail,
- Lists available for all systems that access the database, not just dbFront,
- Easy and robust maintenance via the database or dbFront,
- Makes the database more self documented...
In addition, dbFront now includes a table tool to quickly create a SQL script that will turn a table column into a lookup table.
I would very much appreciate hearing reasons why creating a lookup table is not the best solution. Please add those reasons as comments to this answer.