I have read https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations and also many to one join in QGIS but I can't seem to be able to do a many to one join in QGIS 3.4.
I have many addresses that I want to connect to land parcels, one land parcel can have several addresses on it, some land parcels also don't have addresses (like farmland for instance).
I went to project/properties and added a relation between these two layers (which have a common identifier (the land parcel ID is already connected to each address in the address attribute table, so I used this same info for the referencing and referenced fields), but then I don't see new fields from the address table be displayed in the parcel table and I have no idea how to have it displayed (QGIS documentation talks about "forms for 1-N relations" but it doesn't seem to refer to the attribute table per se. I actually see the child table (address) appear in form view in the parcel attribute table, but in any case I don't seem to be able to add all the features of the address table, the "add child feature" doesn't seem to be doing that even when selecting all features.
Ideally I would like to have the addresses table joined in the parcel table, with new rows for the same parcel with a different address having been created, and rows of land parcels without address left empty (save the parcel info).