Hi Klas

INFO

I have a table (#__cck_map)

In this table I store a content types ID, and the ID of another content that it references.

i.e. My Shoes [id of 456] references Sandals [id of 12], Boots [id of 34] etc.

#__cck_map table would look like this:

id    - fk

456 - 12

456 - 34

So..... in my search form for 'My Shoes' I use the Search - Join Field.

However, because there are multiple instances of '456' in #__cck_map, the results show a total based on each occurrence.

I am looking to add DISTINCT to the query.

QUESTIONS

1: Apart from a free standalone query, is there another way to add DISTINCT?

2: Should Conditionals work on Search Join field? <- of course not!!! it is not rendered

Thanks for any tips

Jon