Questions tagged [many-to-one]
n:1. One, or more, rows in one table are linked (or related) to one row in another table using a "key" column. The opposite of one-to-many.
5 questions
1 vote
0 answers
53 views
Using many-to-one relationship in QGIS
I am not very experienced with QGIS. My goal is to visualize the changing "geography of death" of the Roman emperors over time. The essential available data is the year of death (AD) and the ...
- 11
3 votes
1 answer
214 views
Counting features in child table that are related to the report feature in QGIS
I am building out a report template in QGIS. I have a Field Group Section that generates a report page for every feature in Layer A. Layer B is related to Layer A in a many-to-one relationship like so....
- 89
1 vote
1 answer
127 views
Add many to one relationships to a data table in QGIS
So I have a list of farms (points), and three other layers of catchment zones (polygons). I want to add to the farm list's data table which catchment zones the farms fall into. As there are multiple ...
0 votes
0 answers
329 views
Cannot add child features: parent primary keys are not available
I've been having a lot of trouble with this error, in multiple versions of QGIS/QField (3.22 LTR, 3.24.2, 3.26.2) and have checked out useful answers about getting the uuid of the parent and the ...
- 165
1 vote
1 answer
138 views
Creating relations many to one in QGIS [closed]
I have a vector layer with polygons A, and the second with polygons B. Polygons A includes/are intersected by several polygons B. I want to join the data (just names of polygons) from polygons B to ...
- 21