My query finds records from a set of 3 connected tables (see image below).
The first table Adressen is the main table containing names, addresses etc. that I need, depending on values in the third table.
Some records from Adressen show up several times in the query result, because they have several references in the last table.
(I set the query's settings to Unique values: YES but that does not help, because of these values in the last table ...)
How can I arrange that the query only displays unique records from Adressen?
Table Adressen has a primary key which I might use, but I don't understand how I could do that.
Frank