Foreign key value picker in the data grid

[datlechin]

Problem

Editing a foreign key column means knowing the target row's key by heart. The grid shows an integer, offers no list of what is valid, and accepts anything until the server rejects it on save.

Proposed solution

• On a column with a foreign key, the inline editor offers a searchable list of rows from the referenced table.
• Show a label column beside the key, chosen from the first text column or set per column and remembered.
• Fetch on demand with a search term rather than loading the whole target table, so this stays usable on a large one.
• Keep free typing available for a key that is not in the list yet.

Alternatives considered

Open the referenced table in a second tab and copy the key across.

Related database type

MySQL / MariaDB