I have a problem with duplicate records showing in a search form.
See http://home.c2i.net/wimalie/Alie/search2.bmp
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? :)

Alie :)

Describe this tables and its relationships, please.
Peko