Support setting multiple many to many relationships between two tables

[adrinr]

Description

We currently support multiple many-to-many between the same tables, but the the frontend does not properly support it. This PR is updating the "define relationship" modal to support this config, moving the error message to a clearer field. Also, adding an extra check to make sure that the same column is not used as both foreign keys on a join table, and fixing the initial type load on existing relationships.

Addresses

• https://github.com/Budibase/budibase/issues/14802

Screenshots

Current settings

Can add new relationships between people -> tasks

Cannot reuse the same through and foreign keys (whatever the order)

Cannot set both foreign keys to the same column

Launchcontrol

Support configuring multiple many-to-many between the same tables

[linear[bot]]

BUDI-8746 Multiple Many-to-Many relationships between two tables

[qa-wolf[bot]]

QA Wolf here! As you write new code it's important that your test coverage is keeping up. Click here to request test coverage for this PR!