Foreign keys: drop-down menu to select correct values (feature request) #1523

Hello eveyone,

I have searched the issues and, to my surprise, unless I am wrong, which is quite possible indeed, I didn't find this feature request.
I have tested the daily builds on Windows and It is not implemented yet.

In short, it would be extremely handy to have an option to have a drop-down menu where you can select your values to insert in your table, from a drop-down list, when you have a foreign key activated on a column.

At present this option is implemented in SqliteStudio 3.2.1, an open source software [1] and DBeaver 5.1.6, another open source software (at least as regards the community version...).
Needless to say, this option is available with Microsoft Excel and LibreOffice Calc as well.

See this screenshot for SqliteStudio 3.2.1, where in the column 'frutto' there is drop-down menu to select my values:

See this screenshot for Dbeaver 5.1.6. The column 'frutto' has the option to select the correct values from the table on the right side: