Skip to content

FK dropdown - inline insertion of missing values in FK table #5601

@pawelsalawa

Description

@pawelsalawa

When a user wants to pick FK value, but it turns out he did not fill the referenced value in the foreign table yet. For example user has in foreign table IDs 1, 2 and 3. Then he wants to pick 4, but it's not there yet. Still he should be able to pick 4 and SQLiteStudio will insert it into foreign table with default values, which then user can edit.

Normally user would have to close FK dropdown, then open foreign table, insert row with ID 4 and then go back to the first table and pick FK value with ID=4. It's not that big of a deal, but from UX perspective it's nice if user can finish his pick at once and fill its details afterwards.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions