Annoyance with Supabase Dashboard Table Editor -> Composite Foreign Keys

[dilly-sixmo]

I posted this issue in Supabase Discord and was told I should post it here:

When using composite foreign keys in a data table, the Table Editor's UI for updating a column or inserting a new record can become impossible to use.

For example, If I have a table named project_task_expenses that has columns: id, tenant_id, project_task_id, expense_account_id among others.

id + tenant_id is a composite primary key
expense_account_id + tenant_id is a composite foreign key
project_task_id + tenant_id is a composite foreign key

Now let's say I want to either manually edit the tenant_id for an existing record OR I want to insert a completely new record into this table. And I want to use the Supabase Dashboard's Table Editor to do it. Well here's what happens:

When I go to update/set the tenant_id, I'll see something like this:

And when I click "Select Record", I would expect to just see the records available in the tenants table, but instead I see this:

It makes it basically impossible for me to use the Table Editor in any capacity.