QGIS Form from PostgreSQL evolutive related value column

Question

In PostgreSQL / PostGIS : I have a layer (L1) related by a list values (LV1).

I'm searching for a way to relate L1 to LV1 which :

• Automatically updates LV1 in QGIS if it's updated in PostgreSQL
• Does not require loading LV1 in the QGIS browser

I'm using thid configuration:

enter image description here

• Fjedsen: What have you tried so far? Where are you stuck? Also, you need to provide more information, e.g. is L1 also in the same Postgis database? Why (and foremost how?) do you want to update the layer in QGIS, without loading it into QGIS?

Answer 1

The easiest would be to set your LV1 table(s) to private mode (Menu->Project->Properties...->Data Sources), then they will not appear in the layer panel (that is what you called browser, but in fact it is called layer panel), but are still available in the form editor

enter image description here