Foreign key SQLite Tool?

Question

Is there any tool for SQLite that allows you to enter data using a foreign key?

When writing code, I often have to enter a few sample records into a table. But this is a real pain when you need to enter the original id values ​​instead of quickly choosing options.

For example, if you have a classic “product” table, you may have foreign keys for size, color, and 10 other attributes. I want to be able to start typing a row in the product table, and when the "size" column is selected, I can choose from a small medium or large, rather than an integer.

I know that SQLite requires a newer version to support FK, but this question assumes that there is support, and it is a tool that uses FK to quickly enter data.

Answer 1

Navicat has this functionality.

After testing many (all?) SQLite management tools, I can tell you that this is a rare feature. Therefore, Navicat costs a little money, but if you want auxiliary functions to easily enter foreign key values, this may be the only game in the city on this date.

Answer 2

SQLiteStudio has this feature. It is free (donations accepted) and is actively developing.