Bug report #16446
Many-to-many (N:M) relationship not working on simple case
|Affected QGIS version:||3.3(master)||Regression?:||No|
|Operating System:||Windows 7||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||24355|
I can't make N:M relation working.
In attachment you'll find a small SQL script to create simple tables with restrictions as described here : https://github.com/qgis/QGIS/pull/2522
and a small QGIS project.
There are two issues :
When I create an observation, I can't create an author (auteur) linked to it
When I create an observation, I can't make a relation to an existing author (auteur). There is an error message because the new observation's id is not inserted in the relation table but a null value is inserted which violates not-null constraint.
#3 Updated by Regis Haubourg almost 4 years ago
I tested that and it works for me though selecting rows is not so easy to understand.
In your dataset, the issue is probably that it is empty and that the current table form view shows an empty form, but to actually create a new observation, you need to use the 'add new line" button.
I can share a screen cast if needed