Form component displays _id(s) instead of the display column values for related tables

[otichy]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Cloud
  • Tenant ID: ffuk

Describe the bug
I have authors, titles and title_author tables with n:n relationship between authors and titles (via supabase/postgres). In the data tables or in the table element, the multiple records of authors on the title or multiple titles on the author are displayed correctly by the selected display column (e.g. authors.full_name and titles.title), can be added, deleted etc. But on the form element, the multiple records are displayed by the _id column. New records can be searched and added, but the old ones cannot be deleted (both in design and preview).

To Reproduce
Create an n:n relationship of two tables via a third one where multiple records from one table are associated with a record in the second table. Set display columns. Generate a table with edit modal form or a form. Open the form and check the field with multiple related records.

Expected behavior
The form should have the multiple related records displayed by the display column and it should allow the deletion of those records.

Screenshots
Records for titles in the authors table correctly displayed

Records for titles in the authors form incorrectly displayed as _ids

App Export
I am happy to export, but should I encrypt it?

[linear]

BUDI-8835 Form component displays _id(s) instead of the display column values for related tables

[aptkingston]

Thanks for the export @otichy. I've got it and can reproduce the issue. I've just deleted your comment with the export as it contains credentials to your Supabase Postgres DB.