[BUDI-7568] One to Many relationship is incorrectly inverted

[melohagan]

Checklist

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

Hosting

• Self
  • Budibase Version: develop

Describe the bug I'm getting the error "Null value not allowed for a column." when updating a Postgres table row. I don't know which column is the problem, and my table has a lot of rows so it's not clear which column is triggered the validation error.

Expected behavior The automations update row action step should tell you which column is triggered validation errors.

Screenshots

Which column ??

_BUDI-7568

[melohagan]

The automations were a red-herring. There is a bug with relationships being inverted. Above is a relationship defined as One client -> Many Audit

But in the data grid the relationship is incorrectly inverted. (This is fine in v2.10)

And the Null value not allowed for a column error toast is thrown when attempting to save a client row via a form.