Allen Brown's Flexible search-How do get rid of duplicates?

[joann007]

Hello all! I've created a flexible search like the one described by
Allen Browne at http://allenbrowne.com/ser-62.html. It works great,
except that it shows duplicates records as results. I know why this
happens: I have a one-to-many relationship between my Master table
and
by DocAnalysts and DocTaxes tables. Since each record can have more
than one analyst or tax type, it's showing up multiple times as a
result of the search. Is there any way I can fix this?

The form itself is based on a query that links all three tables by
DocID. I've played around with the unique values/unique records
property with no luck. Allen, if you are out there, help me please!


Thanks guys!

 

[Guest]

Im not familiar with Alans solution but can you amend the query to look as
follows:
SELECT DISTINCT etc.

This will result in unique rows only

 

[Allen Browne]

DISTINCT is a good suggestion. It should work unless you are showing related
records.

Another approach is to use a subquery in the WHERE clause instead of using
all tables in the main source query:
http://allenbrowne.com/subquery-01.html#Search