I have a problem with duplicate records showing in a search form.
The boxes on top show words from a table 1 that are linked to records in table 2 (shown in the grey part below), and which have a relation via an intermediate table.
When selecting one of the words from table 1, records from table 2 are filtered.
Generally however I see that records from table 2 are shown multiple times, in fact as many times as they have a relation with a word in table 1. This independent whether I have searched or not.
I would like to do a kind of search maximum from table 2 by record id.
How do reduce the amount of records so that the grey part does not show duplicates? :)