current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 3 down vote favorite
3

I have 1:m relationship tables in my PostgreSql. I like to show the main table attributes as well as the relational table attributes (like grid rows) in QGIS attribute-edit-form.

What are the entries i have to add to dd_* tables to get this?

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

Starting in QGIS 2.2 (still in development) there will be a new feature that will allow to manage 1:n relations in a very fancy way.

When you open a feature form with a relation, you will the feature attributes and the related atributes connected to it. In the following example the table "reaches" as a 1:n relation to a table "maintenances".

enter image description here

For more information of how will it work take a look into this blog post from Matthias kuhn.

share|improve this answer
    
Thanks a lot!! It is an excellent feature. Is this Relations Management working in current QGIS master? –  Vasudevan Periasamy Jan 23 at 18:58
    
Yes I think so. –  Alexandre Neto Jan 23 at 21:02
    
QGIS 2.1 Freeze has this feature! –  Vasudevan Periasamy Jan 28 at 9:52
add comment
up vote 3 down vote

Another approach will be to show a PostGIS view in QGIS, using 'Instead of triggers' in Postgres for handling CRUD operations. Field widges on the view in QGIS, can ensure the correct input, when updating joined fields from QGIS.

share|improve this answer
    
It is handful for 1:1 relations. But i like to get 1:m relations. Thanks. –  Vasudevan Periasamy Jan 23 at 18:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.