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