Hi - firstly, sincere apologies if this is somewhere on here (I tried checking the feature requests and searching for this feature – but please feel free to link to it if you know it exists somewhere!).
Context: I am using Postgres (AWS) as data source. The data source is relational db (simple primary and foreign key relationships). When “editing” the database in Softr UI, is there a way to access the foreign key relationships through the edit forms? I am only seeing a way to edit the foreign key itself.
Ideal feature(s) maybe would be for 1) Softr to recognize the metadata data of the schema, I suppose (the primary/foreign keys), and allow the ability to access these foreign tables in display UI and edit/add UIs?
I think this feature is available when using the Softr database, correct? For example, when using the dropdown feature in the edit tables, it says that “sync with source” but it is greyed out since I am using Postgres.