Hello!
My applaud to the developers of Saltcorn - it seems to be user friendy but yet versatile, just what I'm looking for. So I really would like to use it, but I've met one difficulty that totally halts me. I hope someone can help me with this:
I have watched several times on YouTube the "Saltcorn table relationships" tutorial but I'm not able to reproduce what they do there. My case is very simple. I have two tables: "Table1" which has as a main parameter "electronic-device" (a number), and then a "Table2" which has a main parameter "installation-site" (also a number). I then add a key in "Table2" pointing to "Table1.electronic-device", and I can manually add electronic-devices to the chosen installation-sites. (There must be a unique relationship so that an "electronic-device" can only appear in one "installation-site"). So far so good. But when I create a view for "Table1", I would like this view to show also as a Join Field the "installation-site", which should appear in the same list-row as the "electronic-device" as the latter was assigned to in "Table2", but I just can't make it work no matter how hard I try. I get no error-messages but the "installation-site" never shows up.
Is there a bug, or is there a trick to solve this? I'm using:
Saltcorn version 1.0.0-rc.5
Node.js version v18.20.4
Database type PostgreSQL 12.20
On Ubuntu Linux 20.04.6
Thanks in advance for somebodys answer.
- Einar