I have two tables which have a relation one to many, because the second table stores the editing history of the first table which has geometry, and they are connected through an ID.

I want to create a read-only Sql Textbox in the first table Qgis forms which value is calculated through a sql statement.

For example if i click on a geometry the field search on the second table for the rows that has the current ID and display the desire data from a certain column.

Like in this screenshot:

enter image description here

Where at the end of the form you can see the displayed records from the other table through a sql statement.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.